Query - Return last 10 days of data (excluding holidays and weekends)

[Guitarzan]

I already have the query set up to not include weekends or holidays. However now what I want to do is have the query return data values for the past 10 dates that are not the weekends or holidays.



My main table is dates with $ amounts. I want it to return 10 days worth of data. I'm just not sure how to do this. Right now I just put in a date range and see how many records (days) it returns and then redo moving my start date up or back if I get more or less than 10 days of data.

[June7]

So you need a function to calculate the StartDate of the range considering holidays and weekends. This is a rather common topic. Search forum or web. Start with https://www.accessforums.net/queries...83/index2.html - see posts starting with 17 for additional links.