sample query to exclude a record from a report

[Guest]

I use an access application that checks for the status of a license such as
active and inactive. I need to exclude the inactive records from printing in
reports.
Can anyone provide a sample query or macro to do this?

 

[Marshall Barton]

I use an access application that checks for the status of a license such as
active and inactive. I need to exclude the inactive records from printing in
reports.
Can anyone provide a sample query or macro to do this?

Just set your query's Criteria for the status field to
whatever value you're using to represent active. If it's
thie string "Active", then the query's SQL would be
something like:

SELECT table.*
FROM table
WHERE Status = "Active"