Am looking for a formula to calculate a running total on a number field using dates as the criteria. For example: I type in 10/31/03 and get that days total; also get the week to date, month to date and year to date total numbers. Is this even possible? Would I have to nest queries for each one and then pull them together in a final query?
date accumilations
- Thread starter TMcD
- Start date
dcx693
Registered User.
- Local time
- Today, 13:25
- Joined
- Apr 30, 2003
- Messages
- 3,263
This is all possible in a single query. You can perform multiple calculations on a field in a query. Look up the Date(), DateSerial(), and DateDiff() functions. This thread might also be useful: records made this week.
Oh, Thank you! I've been trying to get the information posted earlier to work and am not successful. There's mention of needing a date stamp for each record. Would a date field work? If so, how. I've been trying all sorts of things and I think my brain is starting to warp.
Thanks for the suggestion, Wayne. I don't think I've made myself clear, though;my fault...sorry. The data is gathered from an outside source that already has a date field. Now, I don't want to monkey with the data, just gather it in different ways for a report. The report I'm trying to model after one they currently use in Excel. There's a table with various items as row headings and the column headings are Daily, WTD, MTD and YTD. (we're counting units) I've tried the suggestions mentioned and just am not smart enough nor experienced enough to get the darn thing to work. And to be honest, I'm getting a little frustrated in that I think I'm gonna have to tell them I can't deliver what I thought I could. Not that I need to add personal issues here...sorry. Does this explaination make sense? Thanks, Tracy
