Form to table?

C

Confused

I have built an expression in a form to itentify the difference between two
dates. How to I get that information to show up on corresponding table to
create a report?
 
L

Luke Dalessandro

Use the expression in a "SELECT" query, to generate a calculated
field... ie if I just want the difference between two dates, I would:

SELECT table.*, datediff("d",
.[date1],
.[date2] as
Difference
FROM


or something... Then base the report on that query. The "Difference"
field will be available for the report. Or you could just use a
calculated control on the report, just like you did on the form.

Luke
 
Top