Criteria Prompts

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

If I put in the following in the criteria section of a
query:

[Type the name of the person:]

The query will prompt me for a person's name to report
on. However, how do I make it so that if I don't want to
type in a person's name at that prompt, I can circumvent
the prompt and get a report with all names on it??

If anyone knows, please let me know. Thanks

Craig
 
Well, one quick and dirty way is to change your criteria to:
Like [Type the name of the person:]

Then, when you run the query, you can put an asterisk (*) in the dialog box
to see all of the records.
 
Thank you very much, Roger....that helped me out a lot

Craig

-----Original Message-----
Well, one quick and dirty way is to change your criteria to:
Like [Type the name of the person:]

Then, when you run the query, you can put an asterisk (*) in the dialog box
to see all of the records.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

If I put in the following in the criteria section of a
query:

[Type the name of the person:]

The query will prompt me for a person's name to report
on. However, how do I make it so that if I don't want to
type in a person's name at that prompt, I can circumvent
the prompt and get a report with all names on it??

If anyone knows, please let me know. Thanks

Craig
Click to expand...


.
Click to expand...
 
A better way is to put:

Like [Type the name of the person:] & "*"

in the criteria line. With this value, you can get everyone whose
last name starts with a specific letter or letter combination.

--
HTH

Dale Fye


Well, one quick and dirty way is to change your criteria to:
Like [Type the name of the person:]

Then, when you run the query, you can put an asterisk (*) in the
dialog box
to see all of the records.
 
Back
Top