Recent content by ahuntley15

I've cut and past your code into a new module and saved as ModWorkDays but whenever they query is run the same error comes up: "The Form name "Form2" is misspelled or refers to a form that doesn't exsit." The code and the SQL do not contain the word "Form2" is this a common error? Also when...

I am trying to calculate transit times in an access query for a large amount of shipments and need to exclude weekends. I have tried using the SQL functions: MyDays: CntDays([StartDate],[EndDate]) and SELECT [StartDte], [EndDte], DateDiffExclude2([StartDte], [EndDte], "17") as WkDays...