Question How To Calculate a Date Range In a query

[nagiese]

I am trying to write a function in an access 2007 query that will calculate the date range for each of my records based on the month-ending date and the In-transit days assigned to each record (excluding any weekend days) (i.e. if the in-transit days number is 5 & the month ending date is 5/26/12 then my date range would be 5/22/12-5/25/12). I want the funtion to calculate the range, I cannot use parameters as each record will have a different range based on it's in-transit days . Can anyone please help me with writing that function? :banghead:

 

[John Big Booty]

Welcome to the forum.

I believe the article here will provide a solution for you.