HI All:

running Access 2000.

I have a report not tied to a form that I have multiple parameters.

I need to have of the the fields give me all records if that parameter is left blank or give me whatever based on the user entry.
What I do when I have a form is something like

[Forms]![frmLocationSpecific]![Location] Or Is Null

but since I am not running it from a form I'm stumped. I tried

[Tables]![tblMyTable]![MyField] ir is Null

but it is not working.

Any help is welcome.

thanks

I got it. Thanks anyhow. :D