C
Chris Simpson
I am having some problems getting a Date lookup to work properly. I am using
code from http://allenbrowne.com/casu-08.html method #2. It all works fine
until the report is opened. In the Query that the report is pulling its data
from my date fields are of type string. This Query is being generated from
tables that are linked from a MS SQL database. If I type in a start date of
2/18/2007 and EndDate of 2/24/2007 in my form, my report generates but I
receive data for 2/2/2007. If I try to change the format of the date fields
using DateValue or CDate in my query I get data type mismatch errors when it
tries to open the report. Do I need to change my query somehow or my where
statement that I am using in my OpenReport command.
Thanks,
Chris
code from http://allenbrowne.com/casu-08.html method #2. It all works fine
until the report is opened. In the Query that the report is pulling its data
from my date fields are of type string. This Query is being generated from
tables that are linked from a MS SQL database. If I type in a start date of
2/18/2007 and EndDate of 2/24/2007 in my form, my report generates but I
receive data for 2/2/2007. If I try to change the format of the date fields
using DateValue or CDate in my query I get data type mismatch errors when it
tries to open the report. Do I need to change my query somehow or my where
statement that I am using in my OpenReport command.
Thanks,
Chris