Date range query using data from form (1 Viewer)

ITguy1981

Registered User.
Local time
Yesterday, 20:10
Joined
Aug 24, 2011
Messages
137
I currently have a query that has the user enter a starting date and an ending date. What I would like to do is use a form with two date pickers and have the query use the two date pickers for the criteria, but i'm not sure what the syntax would be in the criteria field in the query. If I new what the structure of the criteria had to follow I can fill in the text box names, control box names, form name, etc. Sorry for so many posts, but it just seems that all of the google searching in the world just keeps giving me VB code that someone has written.
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 17:10
Joined
Aug 30, 2003
Messages
36,124
In design view

Between Forms!FormName.FromTextboxName And Forms!FormName.ToTextboxName
 

ITguy1981

Registered User.
Local time
Yesterday, 20:10
Joined
Aug 24, 2011
Messages
137
Thanks again Paul. You're great. :)
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 17:10
Joined
Aug 30, 2003
Messages
36,124
Happy to help!
 

Users who are viewing this thread

Top Bottom