Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Greater than [yearEnding]

Status
Not open for further replies.
johngordon

johngordon

Technical User
Jun 29, 2002
112
0
0
US
I am trying to pull all records that are greater than a date set in a field named [yearEnding]

Can someone help me with this one. I have tried using different date criteria as listed in Access' help files and have been unable to make it work proplery.

Gracias,

John
 
Sort by date Sort by votes
what table is this field in or is it on a form. And what table are you trying to pull all the records that are greater then the [yearEnding] value.


Are you trying to create a query to view the results???
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
178
TheresAlwaysAWay
TheresAlwaysAWay
NSNewey
  • Locked
  • Question
Something other than AND or OR
Replies
8
Views
95
NSNewey
NSNewey
jjlogan
  • Locked
  • Question
Specified Field Could Refer to more than one table
Replies
4
Views
56
jjlogan
jjlogan
keun
  • Locked
  • Question
Help me calculate standard deviation for more than one record at a time 1
Replies
2
Views
19
keun
keun
waubain
  • Locked
  • Question
Faster method to UPDATE records in table than .Edit and .Update 1
Replies
6
Views
20
waubain
waubain

Part and Inventory Search

Sponsor

Back
Top