Form to table?

[Guest]

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?

 

[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

 

[Joseph Meehan]

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?

As Luke noted, you normally be better off not storing the result, but
only computing it anytime you want to display or use it.