sample query to exclude a record from a report

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

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?
 
GrouchyMedic said:
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?
Click to expand...


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"
 
Back
Top