Multiple Criterions to generate a report

[MaxEd]

I have an unbounded form that allows the user to make selections to various ID's that are held in combo boxes. Now based on the selection of the drop down boxes/text box entries, I would like to generate a report specifically based on those selections. However the problem I am running into is that I can't do it all in one query using conditional statements.

Here's the generic iff conditional statement I am using.

iif(isnull(forms!formReports!control),is not null or is null,forms!formReports!control)

For fields with dates I enter
iif(isnull(forms!formReports!control),is not null or is null,between forms!formReports!control and forms!formReports!control2)




-Laughter works miracles.

 

[willir]

MaxEd

Have you used VBA.

You have a lot more "procedural" control in preparing to run your report.

 

[MaxEd]

I sort of have an idea how to fix it. I think for the table design I need to have Zeros for the fields that contain numbers and the dates I can sort of cheat my way through it by maxing out the date ranges if they are blank. Yes I use VBA and prefer to use it rather than trying to figure out macros because I started with VB.

-Laughter works miracles.