Compare two dates

  • 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.
 
you will need to build a query that contains all the fields you wish to
pull. Because you are looking for two "or" criteria, you will make entries
on two separate lines in the criteria section of the query. Each line at
the bottom of your query is an "or" statement.

Under the DCSUM feeld you would enter "IS NULL" on what line.

On the second line you would enter ">[DOD]+10"


Don't include the quotatin marks when you enter the criteria above.

Rick B



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.
 
that should say...

Under the DCSUM field you would enter "IS NULL" on one line.



Rick B



you will need to build a query that contains all the fields you wish to
pull. Because you are looking for two "or" criteria, you will make entries
on two separate lines in the criteria section of the query. Each line at
the bottom of your query is an "or" statement.

Under the DCSUM feeld you would enter "IS NULL" on what line.

On the second line you would enter ">[DOD]+10"


Don't include the quotatin marks when you enter the criteria above.

Rick B



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.
 
Back
Top