problem with reports based on a given criteria

S

Sharon

Hello,

I have a report that contains subReports that are based
on queries.

The user can choose which criterias the report will be
opened on like: age, name, date and so on.

Since one sub report deals with the date and the main
report deals with the name, age and so on, I encountered
some problems with the criterias.

I have 2 queries for 2 sub reports for the dates.
I use one if the user didn't want to determine the dates.
I use the second if the user determined the dates and put
the value the user entered to the date field of the query.

The reason I split it into 2 queries, ie 2 reports, is
that when I asked in the access newsgroup whether it is
possible to put a conditional criteria in a query, I have
been told to split it into 2 queries.

The problem is if I do that, then I have to have reports
and queries to all the possible combinations of the
criterias the user might want.

I am sure there is a better way to do that.

Please help me solve this mess,

Thanks in advance,
Sharon

I would like to be able
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Need some PWA help 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Link a text box based on drop down box with four options MS Word 365 0
Access 2002 change report header text 0
Need Help with a VBA subroutine 0
Custom Parameter Dialogs for Reports 2
Automation of scanned file storage based on content 0

Top