In my DB i have a Check Box along with several other fields. I made a query to only give me records when that check box is checked. I also made a report to print all of my records. I want to be able to first see if there are any records with the check box checked. If it is, i want to print a report that contains only those records and display a msgbox. If it is not, i want to print all reports and output them to Excel. I have absolutely no clue how to do this. I tried using "If RecordCount > 0_Then...", but really don't know how RecordCount works or how to put that into code correctly. Please Help!
Arg!
- Thread starter UTK
- Start date
fatbloater
Registered User.
- Local time
- Today, 01:56
- Joined
- Sep 28, 2004
- Messages
- 36
in the query criteria put =null
