Show One Week at a Time

[Cori]

Hi
I have a database that every one records time spent on different projects. I have the formula to show the daily total, but how would i show the weekly total?

Any help would be wonderful...Thanks

 

[Cori]

sorry

I am sorry, i have serched and serched for what i am looking for and haven't been able to find it.

Here is what i have for my daily totals in my query:
Daily Total: [Vacation]+[Sick]+[Holiday]+[TimeOff]+[GeneralAdmin]+[Meetings]+[Training]+[QASupport]+[ProdSupport]+[PurchSupport]+[ServSupport]+[PartSupport]+[SaleSupport]+[LitigSupport]+[EngSupport]+[ECRProcessing]+[Misc]+[SpecCert]+[46E]+[AB85J]+[AB50J]+[EMS]

I'm looking for a way to make these daily totals add up for a week (sunday - saturday).

If you know of another thread that has this answer i would love the name of it.

thanks for the help

 

[Cori]

I do have a query...that is why i am asking this question...is there a way to make a field that shows me the total for the week in a query/report/form? any of these would work for me...i am just looking for the formula.

 

[Cori]

yes, i thought that is what we were talking about here...sorry if i confused you.

 

[Cori]

Does this help???

SELECT tblCatagories.EmployeeID, tblCatagories.Date, [Vacation]+[Sick]+[Holiday]+[TimeOff]+[GeneralAdmin]+[Meetings]+[Training]+[QASupport]+[ProdSupport]+[PurchSupport]+[ServSupport]+[PartSupport]+[SaleSupport]+[LitigSupport]+[EngSupport]+[ECRProcessing]+[Misc]+[SpecCert]+[46E]+[AB85J]+[AB50J]+[EMS] AS [Daily Total]
FROM tblCatagories
WHERE (((tblCatagories.EmployeeID)=[Enter Employee ID]))
ORDER BY tblCatagories.EmployeeID, tblCatagories.Date;