Creating Reports

  • Thread starter Thread starter ACNS
  • Start date Start date
A

ACNS

I need to create a report showing current clients but not clients that have
left. How do I create the right criteria for this? Any help would be
greatly appreciated.
 
You will need either a Departed Yes/No field for active or a Departed
datetime field.
Then use criteria of 0 (zero) or Is Null.
 
You must log in or register to reply here.

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

Useing SSRS (SQL Reports) with Access 2
report 1
Creating a Report with Multi Criteria 3
Query Assistance (Last or Most Recent) 4
Remove Null fields in a report in address 2
Report for current client 6
Lising in report heady 3
Form with Custom report 2

Back
Top