Can this type of Report be Produced?

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

Question Boy

This is going to be hard to explain in text only but here goes.

I have to create a particular report. I have created the base query
successfully and it retruns

ProjNo ProjName ContractDate BuyDate StartProdDate HrsMec HrsElec HrsTest

Now I need some help transforming this to return a report set like

Month1******************Month2
Week1 Week2 Week3 Week4*Week1 Week2 Week3 Week4

and each week is the split into 3 columns HrsMec, HrsElec and HrsTest

then list each ProjNo ProjName ContractDate BuyDate indicating the
appropriate no of Hrs in the appropriate column ased on the StartProdDate

Why can we add a simple img to this posts. A picture would clarify the
request in a second.

Can this be done? If so how?

QB
 
Duane,

Thank you for taking the time to look over my post. As I said a pic would
be worth a million words in this case. I got permission to upload an image
to a temp location. You can see what I am trying to do. This was the basic
layout previously done in Excel and Now I am trying to recreate in Access.

http://www.fondationdonaldaboyer.org/images/Report_Visual.jpg

Thank you for your help,

QB
 
You could use my calendar report solution and position the text boxes based
on the dates.
 
Back
Top