Hello
I am currently using the statement below which calls a function i have written to calculate the last day of the month which is based on a selection made on a form.
EndMonthdate([Forms]![CreateDataSetFRM]![Combo5])))/)

However as this date only needs to be calculated once i can run it from the form open procedure and stored the value in a public variable in a module. How do i get the public variable in the Query design page.

Cheers
Chris

One way you could do it is to assign the last day of the month to a hidden textBox on the form after the selected date is made and refer to that hidden textbox in the query criteria

Col

Cheers! that's worth considering.