Query in a subform field

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No option to create a list in SharePoint Site 0
Display weeks from a Milestone 0
ASK Field Formatting 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
dynamic calculated field in query 3
Need some PWA help 0
running total of records in query 1
Finding the right style field in VBA 0

Top