Too Many Reports and Queries in Access
Sunday June 22, 2008
In a recent forum posting, Emilia wrote:
"I seem to have too many reports and queries. For example, I have several reports each slightly different with its own query. How do optimize this?"
Do you have any advice for Emilia? Interested in advice on this topic? Visit our forum and join the discussion.
"I seem to have too many reports and queries. For example, I have several reports each slightly different with its own query. How do optimize this?"
Do you have any advice for Emilia? Interested in advice on this topic? Visit our forum and join the discussion.
If the reports are very similar and only the conditions differ for example, query can have parameters to cater to different. suppose u have one query to fetch records having age below 25 one for age above 25 one for above 45 etc., u can have 1 query to accept age as a parameter and one report which can print the required reports