Get Subform Dates

[honey2wood]

Hello to all,

I have a form I am using to display an emloyees details with a subForm displaying dates that they have worked. The subform has a time from and to on each day.


What I need to display on the main form is the first date in the subform and the last date. This is the main problem at the moment. After this I will need to work out the number of weeks between dates.
I hope this makes sence.

Graham

Thanks for reading this.

[jzwp11]

You cannot reference a particular record from the subform, but you can use the domain aggregate functions DMax() and DMin() to pull the data from the same record source that the subform uses.

You will need to set up 2 unbound controls in the main form (one for each function)

The DMax() would look something like this

=DMax("datefield", "recordsourcename", "EmployeeIDfield=" employeeIDfieldintheMainForm)

[honey2wood]

Hi Jzwp11

Thanks for getting back. That sounds so obvious now. I will try it but Ithink that will work.

[jzwp11]

You're welcome. The syntax of the domain aggregate functions can be a little tricky, so please post back if you run into problems.