Build a table depending on a date range.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have this working by using the parameter settings in the build table query.
What I'm wondering about is there a way to use a form to select the dates
and then run the query with a where clause. The reason for doing it this way
is I want to use the calendar function to have the user be able to select the
from and to dates from.
In looking at the docmd.openQuery there doesn't seem to be a way to have a
where clause. Can you use the calendar function within the query? Hope this
makes some sense. Thanks for any help.

Tom
 
Hi,


Proceed a little bit differently. Your query can call a VBA function written
in a standard Access Module. Let that function opens a form that will
display the calendar and then, return the selected date, from the displayed
calendar.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top