Can this type of Report be Produced?

[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 Hookom]

If I understand correctly, you want to move and resize a text box in a
schedule report. If so, check out the calendar reports sample at
http://www.access.hookom.net/Samples.htm.

 

[Question Boy]

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

 

[Duane Hookom]

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