Excluding Weekends
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
I need to build a query that gives a production turn time
([datereceived]-[datesent]). That part is easy, but I also need to exclude
weekends so that only workdays are included in this calculation. The end
result for example being that if the date received was 05/08/06 and the date
shipped was 05/15/06, the result of my query needs to be 5.
TIA
Terry Schawe
.
Relevant Pages
- Re: Does DateDiff Have A Bug
... Now I just use the results from the query and everything works better than ... MemberID FirstName LastName EntryDate DaysRemaining ... calculated field within it's calculation) would look like; ... if there are zero days left which in ...
(microsoft.public.access.formscoding) - Re: Does DateDiff Have A Bug
... I changed the form (Members) RecordSource back to my Main ... Now I just use the results from the query and everything works better than ... MemberID FirstName LastName EntryDate DaysRemaining ... calculated field within it's calculation) would look like; ...
(microsoft.public.access.formscoding) - Re: Does DateDiff Have A Bug
... Now you would go to Queries/Create query in Design View, ... MemberID FirstName LastName EntryDate DaysRemaining ... calculated field within it's calculation) would look like; ... I'm trying to write the result of lngDays when it reaches zero days ...
(microsoft.public.access.formscoding) - Re: Updating all records
... I'm assuming you can write a query that has a unique row for each PartID, ... and which contains one column for each "variable" used in the calculation, ... Dim sExpression as string ...
(microsoft.public.access.formscoding) - Re: Does DateDiff Have A Bug
... Now you would go to Queries/Create query in Design View, ... MemberID FirstName LastName EntryDate DaysRemaining ... calculated field within it's calculation) would look like; ... I'm trying to write the result of lngDays when it reaches zero days ...
(microsoft.public.access.formscoding) |
|
