Expression (used to calculate date diff)

[Guest]

Hi

I have a column in a query which calculates "date diff" for me, this column
appears to work fine when the query is run. I now want to display the
calculated column results in a form, but the column does not appear in the
fieldlist when building my form. I assume this is because the column is
linked to an expression?? So, how do I go about getting the column displayed
on my form?

 

[Douglas J Steele]

You sure you've got the correct query as your RecordSource for the form?

 

[Guest]

Thanks for the reply! You were right, I checked and the openform macro was
pointing to the wrong query! I have managed to correct that, however now the
query pulls up 6 records and the form pulls up only 1 (for the same period).
I have checked that the openform control source is the correct query. What
else could I have missed?

 

[Guest]

What a numb head I am today! The form was set not set to continuous form!
Thank goodmess its friday today. Sorry to waste your time, but thanks for
the help!