I have a request from one of my clients to produce a report that lists all his client information and fee details. My problem is that all the fee information is contained in the one table and I need to pass the query three different paramater values for Directors fees, Takeon fees and Fee listing.
Obviously if I use the where statement to filter my recordset I will exclude the records that don't have values for all of the parameters.
I have seen how subqueries can overcome issues like this by effectively running recursive selects on recordsets but I am not sure if this is the way to go. I have produced a couple of basic subqueries but if anyone who has more experience could guide me as to the suitability of the method or suggest a better approach I would be very grateful.
Thank you kindly,