|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 19th, 2009, 09:19 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Query in a subform field
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. 
|
|
#2
November 19th, 2009, 09:44 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Query in a subform field
Post your DateDiff calulation for suggestions.
-- Build a little, test a little. "Joanne" wrote: 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
