|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 16th, 2008, 04:45 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Date range queries
I'm having problems with date range queries. Can I make these queries when
the person who built the database used "Text" as the "data type" for the date field in the table? In my querie I am using {Between "07/01/2008" And "9/30/2008"} but the brackets are not a part of it. But I am getting October's data also. (The data starts with July so I don't have to worry about before July. 
|
|
#2
October 16th, 2008, 05:21 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Date range queries
Pat
"07/01/2008" is NOT a date, it's a text string. In Access, #7/1/2008# is interpreted as a date/time value. Since what you have stored is text, naturally "10/..." happens before "9/..." (one comes before nine). Consider converting those psuedo-dates to actual date/time values, then sorting by the date/time value. Regards Jeff Boyce Microsoft Office/Access MVP "Pat Hughes" Pat wrote in message ... I'm having problems with date range queries. Can I make these queries when the person who built the database used "Text" as the "data type" for the date field in the table? In my querie I am using {Between "07/01/2008" And "9/30/2008"} but the brackets are not a part of it. But I am getting October's data also. (The data starts with July so I don't have to worry about before July.
|
|
#3
October 16th, 2008, 06:01 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Date range queries
Hi Pat,
Try this: http://www.fontstuff.com/access/acctut01.htm Excellent Site with great information "Pat Hughes" wrote: I'm having problems with date range queries. Can I make these queries when the person who built the database used "Text" as the "data type" for the date field in the table? In my querie I am using {Between "07/01/2008" And "9/30/2008"} but the brackets are not a part of it. But I am getting October's data also. (The data starts with July so I don't have to worry about before July.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
