Filter records

  • Thread starter Thread starter myxmaster
  • Start date Start date
M

myxmaster

Hi,
I have a form that lists transactions. I would like to limit the list
to show transactions from the previous 14 days.

TIA
 
Base the form on a query. Set the criteria for the date field to:
DateAdd("d",-14,Date())
Click to expand...
See Help for more information about the DateAdd function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Action Arguments 1
Graph based on a Query? 4
Access Updating inventory levels 0
Tracking Log 4
How to setup database to make transactions (transfers) between two bank accounts 0
Display message if specific query returns a value 4
Missing something? 3
Aging report 2

Back
Top