weekly data populate on Excel sheet

[psaaccess]

My project is to create weekly schedules on the Access 2000.
I created the query to get the data. Those fields are date(Mon Nov1 …), status, location, type and generate number.
The data has to be only week days From Monday to Friday. The output needs to be populated like below by weekly until 5 weeks for each month.
--------------------------------------------------------------------------------------------------------
week 1 Mon NoV1 | Tue Nov2 | Wed Nov3 | Thu Nov4 | Fri NoV5
--------------------------------------------------------------------------------------------------------
Num, Status, Type, Location | Num, Status, Type, Location | Num, Status, Type, Location|Num, Status, Type, Location | Num, Status, Type, Location
_______________________________________________________________
Week2
_______________________________________________________________
Week3
--------------------------------------------------------------------------------------------------------
Week4
-------------------------------------------------------------------------------------------------------
Week5
----------------------------------------------------------------------------------------
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
My question is how to populate the data from Ms Access query to Excel sheet from Mon to Friday above format.
I am not good programmer in Excel.
This task due date is in two days. I appreciate your help in advance.

 

[Shahzadt]

have you tried using msquery in excel? can post a sample sheet with the format?

 

[psaaccess]

have you tried using msquery in excel? can post a sample sheet with the format?

Hi Shahzadt,

Yes I used msquesry and tried getting ouput is

Status, Type , Location, date
1 completed Il Mon Nov1
2 Completed CA Mon Nov1
3 open IL Tues Nov2

Out put has to be
week1 MonNov1 | Tues Nov2 | Wed Nov3 | Thur Nov4 | Fri Nov5
Status, Type , Location | Status, Type , Location
----------------------------------------------------------------------------------------
week2 MonNov8 Tues Nov9 Wed Nov10 Thur Nov11 Fri Nov 12
Status, Type , Location
---------------------------------------------------------------------------------------
I don't know how to get above output in excel.