including the difference between two dates in query result

[Paul-NY]

Hi


I want to create a simple query in Access 2007 using Query Wizard that includes the difference between two date fields that are stored in the tables I am querying against among other data fields in the query result.

How do I include both the date field values themselves and a field in the query result that calculates the difference between the two dates? This difference is not available in the tables.

Paul

[compooper]

SELECT tblname.[Start Date Field], tblname.[End Date field], DateDiff("d",[Start Date Field],[End Date field]) AS [Date Diff]
FROM tblname

[Paul-NY]

Thanks Com. That would work, is there any way to incorporate it into the Query Design rather than writing it in SQL?

Paul

[Rhino373]

Your third column in the query design in the "Field:" field would be like:
Date Diff: DateDiff("d",[Start Date Field],[End Date field])

Where "Date Diff" is any field name you so choose.