A
accesscrzy
I would like to create a query that the user can specify:
all information before 6/01/2000. <6/01/2000
all information before 6/01/2000. <6/01/2000
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Snell [MVP]
Post the query that you want to filter in this way.
A
accesscrzy
This is what I currently have as the criteria. Users just
enter the date or use "*" as a variable. Some of them
have requested all documents BEFORE 8/01/1999. Any
suggestions?
Like "*" & [Enter Date] & "*"
enter the date or use "*" as a variable. Some of them
have requested all documents BEFORE 8/01/1999. Any
suggestions?
Like "*" & [Enter Date] & "*"
K
Ken Snell [MVP]
Is the field that contains the date formatted as Date/Time format? Or are
you using a text field to store a date? The criteria expression that you're
using suggests that you're using a text field?
--
Ken Snell
<MS ACCESS MVP>
you using a text field to store a date? The criteria expression that you're
using suggests that you're using a text field?
--
Ken Snell
<MS ACCESS MVP>
accesscrzy said:This is what I currently have as the criteria. Users just
enter the date or use "*" as a variable. Some of them
have requested all documents BEFORE 8/01/1999. Any
suggestions?
Like "*" & [Enter Date] & "*"
-----Original Message-----
Post the query that you want to filter in this way.
--
Ken Snell
<MS ACCESS MVP>
.
A
accesscrzy
Yes.. it is in text format because not all documents had
the same date format.. ie August 1998 - 1999, some just
have a month on them.
the same date format.. ie August 1998 - 1999, some just
have a month on them.
-----Original Message-----
Is the field that contains the date formatted as Date/Time format? Or are
you using a text field to store a date? The criteria expression that you're
using suggests that you're using a text field?
--
Ken Snell
<MS ACCESS MVP>
This is what I currently have as the criteria. Users just
enter the date or use "*" as a variable. Some of them
have requested all documents BEFORE 8/01/1999. Any
suggestions?
Like "*" & [Enter Date] & "*"
wrote-----Original Message-----
Post the query that you want to filter in this way.
--
Ken Snell
<MS ACCESS MVP>
"accesscrzy" <[email protected]>
in messageI would like to create a query that the user can specify:
all information before 6/01/2000. <6/01/2000
.
.
K
Ken Snell [MVP]
If your date data are in such widely varying forms, it will be very
difficult to write a query that will correctly, 100% of the time, find the
data based on entering a date as a parameter. How is ACCESS going to
understand a date of "August 1998 - 1999" when it's asked to find dates
later than January 1, 1999, for example?
You will need to clean up the data (change all to a standard format that you
can teach ACCESS) before you'll be able to set up a query to find the
desired records.
--
Ken Snell
<MS ACCESS MVP>
difficult to write a query that will correctly, 100% of the time, find the
data based on entering a date as a parameter. How is ACCESS going to
understand a date of "August 1998 - 1999" when it's asked to find dates
later than January 1, 1999, for example?
You will need to clean up the data (change all to a standard format that you
can teach ACCESS) before you'll be able to set up a query to find the
desired records.
--
Ken Snell
<MS ACCESS MVP>
accesscrzy said:Yes.. it is in text format because not all documents had
the same date format.. ie August 1998 - 1999, some just
have a month on them.
-----Original Message-----
Is the field that contains the date formatted as Date/Time format? Or are
you using a text field to store a date? The criteria expression that you're
using suggests that you're using a text field?
--
Ken Snell
<MS ACCESS MVP>
This is what I currently have as the criteria. Users just
enter the date or use "*" as a variable. Some of them
have requested all documents BEFORE 8/01/1999. Any
suggestions?
Like "*" & [Enter Date] & "*"
-----Original Message-----
Post the query that you want to filter in this way.
--
Ken Snell
<MS ACCESS MVP>
in message
I would like to create a query that the user can
specify:
all information before 6/01/2000. <6/01/2000
.
.