Daily totals, weekly totals, monthly totals, quarterly totals, yearly.

[jeffcravener]

totals...

How do I do this....I made the date all sep fields...like 4/23/2003 is entered into 3 sep fields, month, day, year..

I figured this would make it easy...

I can do daily, i can do monthly, i can do qurteryl, and i can do yearly...but how do i do a weekly total?

 

[Trendsetter]

Get all the dates you want to work with and format them in WeekNum , then you can group all the same WeekNums together and sum for each number

 

[jeffcravener]

(Is it even necessary fr me to split my date up like i described? Or is access versatile enough that if they enter the date i can rip it aprt later?)

So, this weeknum assigns a number to each week in a month?

What about when the week is a slit between two months...its the last week for one month, but the first of another?

 

[jeffcravener]

to expand on the parenthesis question above: if i have them just enter the date, will access know that 4/23/02 is a tuesday?

 

[Trendsetter]

Access has functions for WeekDay which gives the day of the week but you have to set what day your week starts (Sunday or Monday)

WeekNum ignores months and specifies a number for each week of the year - great for timesheets and logging worked hours etc...

So the date you input can be specified by the day and the week