report/query settings

  • Thread starter Thread starter karim
  • Start date Start date
K

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...
 
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)
 
well, I tried this and it worked:
= [Enter Person Name:] IS NULL

it is basically a combination of what you gave me... thank alot.
 
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!)


karim said:
sorry, I take that back. it still not working


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

it is basically a combination of what you gave me... thank alot.
Click to expand...
Click to expand...
 
Back
Top