Counting the Days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a query i'm tring to calculate days away
example:
[DateReturned]-[DateLeft]
But I would like to calculate [DateReturned] as Date() untill an accual date
has been entered.
 
Try (the lazy way):

IIf( IsDate([DateReturned]) = False, Date(), [DateReturned]) - [DateLeft]
 
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

open a subform or hide it based on query results 15
Validation Rule Problem 3
Someone Please Assist me with Expression ? 2
IIf statement in Access 2003 query 9
Error 3612: Multi-level GROUP BY clause is not allowed in subquery 4
Creating an update query that uses multiple parameters 2
Counting Days between two Dates excluding weekends 2
Append from main table to related table 2

Back
Top