Criteria Option in Access 97?

[robWhitz]

Currently, I have a query that prompts the user to enter name (e.g. Enter Student Name), which it will then list down the student information as defined in the query.

How can I customise the query in a way that when I left the prompt blank or 0, it will return me the names of all the students?

Please help.

 

[tlbroadbent]

Where columnA = [Enter Student Name]
Or [Enter Student Name] Is Null Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[CosmoKramer]

Or

Like [Enter Student Name] & '*'

The only downside is it will return multiple partially entered names: SMITH will return all students with the last name of SMITH. I usually use this with combo boxes where the user either selects an entry or a blank to select all...

 

[robWhitz]

Thanks for your help, guys. Got it up and running.