<date

[accesscrzy]

I would like to create a query that the user can specify:
all information before 6/01/2000. <6/01/2000

 

[Ken Snell [MVP]]

Post the query that you want to filter in this way.

 

[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] & "*"

 

[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>

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>




.

 

[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.

-----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>

"accesscrzy" <[email protected]>

wrote
in message

I would like to create a query that the user can specify:
all information before 6/01/2000. <6/01/2000


.

.

 

[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>

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


.

.