Need to sort data

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

Guest

I have a customer database and need to pull two reports. One for active
customers only and one for all customers. How do I achieve this? I am verry
new to access.
 
JShumaker said:
I have a customer database and need to pull two reports. One for active
customers only and one for all customers. How do I achieve this? I am verry
new to access.
Click to expand...

I'd create two queries; one to show just the active customers and one for
all customers. In the first query, you might have a field called Status to
tell if a customer is active or not. In the Criteria row, put

="ACTIVE"

or whatever word you use to designate an active customer. If you use a
check box for active customers, just use

True

as the criterion.

Tom Lake
 
Back
Top