Query compairison

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

I have a table that contains two dates. One date is the date of discharge
(dod) the second is the date the paper work for discharge is completed (DC
SUM). The DC SUM is often blank pending the users input when it is
completed. Both fields are date formated.

I am trying to create a query that shows me which entires are blank or more
than 10 days after the DOD.

I am new to access and having a hard time getting the query to return te
result taht I want.
 
I am trying to create a query that shows me which entires are blank or more
than 10 days after the DOD.

I am new to access and having a hard time getting the query to return te
result taht I want.
Click to expand...

Try a criterion of
= DateAdd("d", 10, [DOD]) OR IS NULL
Click to expand...
 

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

Compare two dates 2
Using an IIF Statement to calculate discharge date 4
Annual Census 2
dates in queries 1
select query including dates outside of specified range 2
Joining 3 Queries That Count 8
another multiple IIf 2
What do I need: multiple nested IIF? Switch()? DateDiff? 2

Back
Top