report/query settings

[karim]

Hello All,
I have a report that is filtered by name, date, dept. Is there a way
to make it so that you can only fill 2 out of the 3 filters and it shows you
the result. so lets say, if I filled date, and dept. it ignores the name and
show me all result including all names? right now, if I do that, the report
shows 0 records...

any help would be greatly appercialted...

 

[Douglas J. Steele]

Presumably your report is based on a query that has criteria.

Assuming you've currently got something like [Enter Person Name:] as the
criteria under the Name field, change it to = [Enter Person Name:] OR
([Enter Person Name:] IS NULL)

 

[karim]

Thanks for the fast replay. I tried that but it did not work.

 

[karim]

well, I tried this and it worked:
= [Enter Person Name:] IS NULL

it is basically a combination of what you gave me... thank alot.

 

[karim]

sorry, I take that back. it still not working

 

[Douglas J. Steele]

Go into the SQL of the query and explicitly change it from

[MyTable].[MyField] = [Enter Person Name:]

to

[Myable].[MyField] = [Enter Person Name:] OR ([Enter Person Name:] IS NULL)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

sorry, I take that back. it still not working

well, I tried this and it worked:
= [Enter Person Name:] IS NULL

it is basically a combination of what you gave me... thank alot.