var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: find week days in query
i want to be able to find all the weekdays between to date in a query so i can run a report off that query. can any1 help
Vague question.....vague answer:
SELECT * FROM myTableName WHERE SomeDate BETWEEN #" & Me.StartDate & "# AND #" & Me.EndDate & "#;"
Self Taught In ALL
Environments.....And It Shows!
For Week Day pehaps this
SELECT * FROM myTableName WHERE SomeDate BETWEEN #" & StartDate & "# AND #" & EndDate & "# AND (Weekday(SomeDate)>1 AND Weekday(SomeDate)<7);"