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
|
|||
|
|||
Querying Dates
Hello,
I have a query with information in it and then one of the fields is a date field. I would like to further query it so that it only takes the information for the people that are before a certain date. Everything after that date I dont want. For ex: name address date Jane Doe Whatever St. 12/3/08 Doe Jane Who Knows St 12/15/09 I would like to quere out the people that have a date before 12/10/09. I tried when I do my query to just put under the date field 12/10/09, but that didnt work for some reason. It's seems simple enough, I just can't get it off the top of my head. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200912/1 |
#2
|
|||
|
|||
Querying Dates
I figured it out. When I imported it in, Access put the date field as a text
field and not a date field. Switched it and it worked fine. scottydont2121 wrote: Hello, I have a query with information in it and then one of the fields is a date field. I would like to further query it so that it only takes the information for the people that are before a certain date. Everything after that date I dont want. For ex: name address date Jane Doe Whatever St. 12/3/08 Doe Jane Who Knows St 12/15/09 I would like to quere out the people that have a date before 12/10/09. I tried when I do my query to just put under the date field 12/10/09, but that didnt work for some reason. It's seems simple enough, I just can't get it off the top of my head. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200912/1 |
#3
|
|||
|
|||
Querying Dates
The criteria you used is interperted as 12 divided by 10 divided by 9.
Use this -- #12/10/09# -- Build a little, test a little. "scottydont2121 via AccessMonster.com" wrote: Hello, I have a query with information in it and then one of the fields is a date field. I would like to further query it so that it only takes the information for the people that are before a certain date. Everything after that date I dont want. For ex: name address date Jane Doe Whatever St. 12/3/08 Doe Jane Who Knows St 12/15/09 I would like to quere out the people that have a date before 12/10/09. I tried when I do my query to just put under the date field 12/10/09, but that didnt work for some reason. It's seems simple enough, I just can't get it off the top of my head. Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200912/1 . |
Thread Tools | |
Display Modes | |
|
|