Query to show me records > 10 days

[goosehunter]

Good morning all you smarties! I don't think this is too challenging but I was wondering if you could help me with a query. I need to create a report that lets me know of all patients who have a "date of service" greater than 10 days and my "billed" check box is not checked. Any help is greatly appreciated!

 

[Philem]

Hullo. In your query design, in the Criteria for "Date of Service" put >10, and in the Criteria for "Billed" on the same line as the "DoS", put Is Null.

HTH

P