criteria s/b which adm or give me all

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone! Happy Friday!!! A long weekend is approaching!!! Using A02
on XP.

Have a query that pulls all payment types for a specific period. I need to
be able to pull either only the records where [Admin] equals certain initials
but if I don't type in any initials, I'd like to get all the records. I have
this - [Which Administrator Initials? XXX] in my criteria line and if I key
in initials (with records), I get just those records but if I leave it blank
and click okay, I get zero records. How can I tell it to give me all the
records?

Hope I've described it well enough and will appreciate any assitance or
advice. Thanks in advance for your time.
 
Barry! You are the greatest! Thanks bunches, it works like a charm!
--
Bonnie


Barry Gilbert said:
Try:
Like "*" & [Which Administrator Initials? XXX]

Barry

Bonnie said:
Hello everyone! Happy Friday!!! A long weekend is approaching!!! Using A02
on XP.

Have a query that pulls all payment types for a specific period. I need to
be able to pull either only the records where [Admin] equals certain initials
but if I don't type in any initials, I'd like to get all the records. I have
this - [Which Administrator Initials? XXX] in my criteria line and if I key
in initials (with records), I get just those records but if I leave it blank
and click okay, I get zero records. How can I tell it to give me all the
records?

Hope I've described it well enough and will appreciate any assitance or
advice. Thanks in advance for your time.
Click to expand...
Click to expand...
 
Back
Top