Simple DateDiff query

H

Homer

Here it is:

I have a form which contains the opening date and the resolved date
and I'm trying to workout how many days it takes from opening to
resolution. Is there a way to write a sql query to do this? Or can I
write a formular in the table to show this? Or can I get a text box on
the form to tell me this and then feed this through onto the table?
I've been working on this all morning and would appreciate any help
you can give me.

Thanks,

PAR
 
K

Klatuu

You do not want to keep this data in the table. You don't store calculated
values.

Add a column to your query to calculate it. It is called a Calulated Field.
In the query builder, give it a name in the Field cell, followed by a colon,
followed by the calculation. For example:

DaysToComplete: DateDiff("d", [OPENING_DATE], [RESOLVED_DATE])
 
Top