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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aging Query 1

Status
Not open for further replies.
lgvelez

lgvelez

Technical User
Jun 6, 2000
108
US
How would I create a query with aging criteria for:
under 30 days, between 31 & 60 days, between 61 and 90 days, etc. I would also like to set it up with a now() function so that it can be used without rebuilding every time. The info is coming from one table, which I would add to the grid multiple times to access the one field with the needed date.
TIA, Laura
 
Sort by date Sort by votes
Hi, what are you aging? Unpaid Invoices or just balance >0 from some field?, what is your table name and the fields?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
710
jedraw
jedraw
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
335
dhookom
dhookom
BradCustom
  • Locked
  • Question
Convert Access query to SQL query
Replies
5
Views
389
strongm
strongm
Bill6868
  • Locked
  • Question
Query Expression Question
Replies
3
Views
295
Andrzejek
Andrzejek
mwiinde
  • Locked
  • Question
How to Convert Ms Access query data into Json String
Replies
0
Views
450
mwiinde
mwiinde

Part and Inventory Search

Sponsor

Back
Top