Employee Forecast in Access Help!

[joey201]

Hello,



I have this Excel file to Forecast employee need where I have columns 45 to 44 representing weeks in a fiscal year. Each row belong to a project with the information needed to calculate how many employees I need for that week. I use a macro to calculate how many employees I need for a particular week taking in mind that one project can take 4 to 6 weeks to accomplish. The macro simply puts how many employees I will need for week 1, week 2 etcetera in that week column at the end I just sum the column to get the employee need for that week across all project.

I need to do this in access I tried using a crosstab query and while it works it just calculates 1 week. I also tried making multiple crosstabs and joining them with a select query using output all fields but it repeats row headings so I end up with multiple columns with the row heading.

attached is a screen with how it works in excel.

[ranman256]

a crosstab should would to show ALL weeks.
the base query ,Q1 should pull add data for all weeks.
then Q2,the crosstab, should use Q1 to flip into your grid above.

[ssanfu]

Maybe post your Access dB for analysis???