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

Search results for query: *

  • Users: cob5
  • Content: Threads
  • Order by date
  1. cob5

    Query Criteria - Date Ranges

    I have a query that currently requires manual input of the first and last day of the month to execute the query (i.e. dec-01-01 and dec-31-01). Does anybody know how I can add a criteria (I know zero about SQL or codes) that automatically makes it Between first AND last days of the current...
  2. cob5

    Field criteria for previous week

    I am new to access and have a query that links 3 tables. It is a pretty simple query but I need to make the date field criteria pull only information from the last week. I can manually change the criteria every week, but I want to have it automatic so that it can be added to a weekly macro that...

Part and Inventory Search

Back
Top