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

query for past due billing

Status
Not open for further replies.
brandys

brandys

MIS
Dec 12, 2002
6
US
I am creating a billing database and would like to be able to query the bill date to determin if the bill is past due 30 days. I have not been working with access long and need all the help that i can get.
brandys
 
Sort by date Sort by votes
Create a query which has billdate in it and set a criterion in the query grid <=date() - 30
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

puforee
  • Locked
  • Question
Best way to setup tables for multible related data sets
Replies
1
Views
310
dhookom
dhookom
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
319
dhookom
dhookom
oxicottin
  • Locked
  • Question
Creating tables and relationships for new database
Replies
2
Views
2K
MajP
MajP
MattGreer
  • Locked
  • Question
Is it &quot;bad&quot; to have a Lookup table/query in a table? 2
Replies
4
Views
150
MattGreer
MattGreer
Eutychus
  • Locked
  • Question
ODBC connection to SQL Server tables for runtime version of Access
Replies
4
Views
162
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top