Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

jeffcravener

Technical User
Apr 10, 2003
37
US
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?
 
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
 
(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?

 
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?
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top