Querying Dates
in [Form]
|
From: scottydont2121 via AccessMonster.com on 22 Dec 2009 10:21 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/Forums.aspx/access-forms/200912/1
From: scottydont2121 via AccessMonster.com on 22 Dec 2009 10:59 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/Forums.aspx/access-forms/200912/1
From: KARL DEWEY on 22 Dec 2009 11:11 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/Forums.aspx/access-forms/200912/1 > > . >
|
Pages: 1 Prev: lucenilaugusto@hotmail.com Next: User defined Function to use data direct from table??? |