Expression (used to calculate date diff)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
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!
 
Back
Top