Im trying to build form with two calendar controls which asks query for records between two dates.
Calendar control works fine, no problem with that, but my query isnt.
What im trying to do:
I have a table with records, each record has field with date of creation (for example 2007.11.25.) formated as date/time (im working with latvian local settings)
In my form, I have a two text fields which referes to each calendar control, so in query (whith is trigered by comand button) i have formula like this:
Between [Forms]![Form1]![text5] And [Forms]![Form1]![text7]
Everything seams to be fine (for me ) but if im searching dates between 2007.01.01. and 2007.03.01. im getting not only correct records between those dates, but also random records from last year.
I have tryed many diferent formulas, but nothing is working, Im stuck in this.
Ofcourse, my problem is that Im not good with VBA I dont understand it at all
Sorry if someone allredy posted solution of my little problem somewhere in Jungles of these Treads
Calendar control works fine, no problem with that, but my query isnt.
What im trying to do:
I have a table with records, each record has field with date of creation (for example 2007.11.25.) formated as date/time (im working with latvian local settings)
In my form, I have a two text fields which referes to each calendar control, so in query (whith is trigered by comand button) i have formula like this:
Between [Forms]![Form1]![text5] And [Forms]![Form1]![text7]
Everything seams to be fine (for me ) but if im searching dates between 2007.01.01. and 2007.03.01. im getting not only correct records between those dates, but also random records from last year.
I have tryed many diferent formulas, but nothing is working, Im stuck in this.
Ofcourse, my problem is that Im not good with VBA I dont understand it at all
Sorry if someone allredy posted solution of my little problem somewhere in Jungles of these Treads
Attachments
Last edited: