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.
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.