L
Lanstone
I am currently having issues filtering data in a query. I have linke
an Excel Spreadsheet and a data table in Access. The Excel tabl
contains Sales Order data. The Access table is linked to an Acces
form in which a Start and End date are retrieved from a user. Thes
user dates are then used in the Access query, which is filtered agains
a Scheduled Ship Date in the linked Excel table. The Scheduled Shi
Date has the format of 'm/d/yyyy h:nn'. I currently have no format se
on the Access dates. I can't seem to find the correct format.
I use 'Between [REPORT-SEL]![SDAT] And [REPORT-SEL]![EDAT]' in th
Query Criteria for the Scheduled Ship Date filter.
I have tried going into the Excel and setting the format there. Then
try to set the format to the same thing in the form used to input th
dates in Access. To look at the linked Excel file, it doesn't appea
to have the time stamp with the date, UNTIL you click on one of them
then you can see it is still there.
Consequently, as an example, I enter a Start Date of '01/01/2006' an
an End Date of '01/20/2006', even though there are definitely record
with the Scheduled Ship Date of '01/20/2006', I get everything BU
those dates - whatever the end date value is, I get everything up to
but not including the end date itself.
Any one have any suggestions? I'ved tried making all the formats matc
between the user input form and the Excel spreadsheet. Even though
have experience, it's not alot. I have a work-around in place - I us
'Between [REPORT-SEL]![SDAT] And DateAdd("d",1,[REPORT-SEL]![EDAT])'
and this seems to work, but I have run up against this very sam
problem in 2 different Access databases in the past week. If there i
a way to do it correctly, I'd rather do it that way - I want to do i
right! Not use a work-around.
Please forgive me for using CAPS in some of my question (other than th
filter statement) - I use it as a form of emphasis - not yelling.
Believe me. I man a Help Desk here where I work and I roil at peopl
who submit their problems in all caps - I feel like I'm being yelle
at....
Anyway, thanks for any help you can suggest. It's would be very muc
appreciated
an Excel Spreadsheet and a data table in Access. The Excel tabl
contains Sales Order data. The Access table is linked to an Acces
form in which a Start and End date are retrieved from a user. Thes
user dates are then used in the Access query, which is filtered agains
a Scheduled Ship Date in the linked Excel table. The Scheduled Shi
Date has the format of 'm/d/yyyy h:nn'. I currently have no format se
on the Access dates. I can't seem to find the correct format.
I use 'Between [REPORT-SEL]![SDAT] And [REPORT-SEL]![EDAT]' in th
Query Criteria for the Scheduled Ship Date filter.
I have tried going into the Excel and setting the format there. Then
try to set the format to the same thing in the form used to input th
dates in Access. To look at the linked Excel file, it doesn't appea
to have the time stamp with the date, UNTIL you click on one of them
then you can see it is still there.
Consequently, as an example, I enter a Start Date of '01/01/2006' an
an End Date of '01/20/2006', even though there are definitely record
with the Scheduled Ship Date of '01/20/2006', I get everything BU
those dates - whatever the end date value is, I get everything up to
but not including the end date itself.
Any one have any suggestions? I'ved tried making all the formats matc
between the user input form and the Excel spreadsheet. Even though
have experience, it's not alot. I have a work-around in place - I us
'Between [REPORT-SEL]![SDAT] And DateAdd("d",1,[REPORT-SEL]![EDAT])'
and this seems to work, but I have run up against this very sam
problem in 2 different Access databases in the past week. If there i
a way to do it correctly, I'd rather do it that way - I want to do i
right! Not use a work-around.
Please forgive me for using CAPS in some of my question (other than th
filter statement) - I use it as a form of emphasis - not yelling.
Believe me. I man a Help Desk here where I work and I roil at peopl
who submit their problems in all caps - I feel like I'm being yelle
at....
Anyway, thanks for any help you can suggest. It's would be very muc
appreciated