Query in a subform field

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

Hello,
I have a database that tracks vacation time. The main form has the basic
employee information and the subform has a list of all the days taken. If
someone takes off Nov. 23-24, the calculated field at the end of the row will
list 1 day. However, this calculation is not working. (I'm using DateDiff).
So I decided to write a query which does work, but I'm not sure how to
attach this query to the calculated field. Is this possible to do?

Thanks very much.
 
Back
Top