ACCESS 2000 PARAMETER QUERY

  • Thread starter Thread starter Gregg
  • Start date Start date
G

Gregg

How do you make an Access 2000 parameter return a msg like
"No Records Found" if in fact there are no matching data
for the input data? Normally, Access returns a blank
record to indicate no records found.
 
Sorry, not in a Query. A Query simply returns a Recordset which can simply
be an empty row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query No Results - Needs to Auto Create Record 4
Null date parameters 2000 2
How do I make query parameters with a drop down list? 1
SQL Select Query Prompting for NonExistent Parameter 8
Parameter Queries 3
parameter query 7
parameter with iif statement in query criteria 8
Access 2000 append unbound text box values to a table 0

Back
Top