Need help with a query search

[Buns1976]

Hi Everyone,

I am very new to Access and need some help with some queries. I have one Table that contains a Date, PLUNumber, Description, PriceEach, ItemsSold, and TotalSales fields.

I have a date range query already set up but I am looking for a way to enter a scan or type a description in a search box with a date range picker
and show that item for the dates selected.

Any help would be greatly appreciated.

Thank you!

 

[thienlyhd]

Can you send everyone a demo file online?

 

[Buns1976]

Thanks for the reply. Link below.

Thank you!




https://www.dropbox.com/sh/i18hy7sqbbpmqbl/AAAN5afkoQTNsd1ymMFajC4ka?dl=0

 

[xenou]

Hi, the simplest way is to use the filtering features on the ribbon or available with right-clicks. Writing your own search routines is possible but generally an unpleasant task and one with a few pitfalls in it, compared to the ready-to-go filtering features that Access provides.