If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MS ACCESS question

eurotrotter · 2007-04-17 17:50:17

just wondering how i might be able to create a report in MS access to show the number of cars sold per week.but the problem is: i have the date next to each car sold, but i need to get a total cars sales per week figure and create a barchart in the report, to represent this data. any ideas how id do this? thanks

Options

17-04-2007 6:50pm

#1

eurotrotter

Registered Users Posts: 1,073 ✭✭✭

Join Date: June 2005

Posts: 378

just wondering how i might be able to create a report in MS access to show the number of cars sold per week.but the problem is: i have the date next to each car sold, but i need to get a total cars sales per week figure and create a barchart in the report, to represent this data. any ideas how id do this?
thanks

0

Comments

Options
#2 17-04-2007 7:22pm
knird evol

Banned (with Prison Access) Posts: 1,007 ✭✭✭

Join Date: May 2006

Posts: 995

u could have another table tbWeekTotals07 with
weeks 1 to 52. this has a field for start date and end date.
each time a new sales record is entered into the
sales table that function runs the sales date through each record in WeekTotals to see if its both greater than start date and less than end date
and if it is increments the fourth field 'total' of that week.

0