L
learning_codes
Hi,
I don't know where to start. I would be appreciated your help. I
have approximately 850 records (Table 1)
Table 1 has 100 Field Names that have a product name but should be a
value not the field name. It is very difficult to explain but I will
make it an example:
I want to create a button to do the work from Table #1 to Table #2.
When I import the data from excel spreadsheet to Access XP and Product
A, B, C become Label but it should be value than label. Table #1 is
the same format as excel spreadsheet.
TABLE #1
OrderID Product A Product B Product C........... up to 100
1 Mon Wed
Fri Mon to Fri
2 Tues Fri
Thurs Mon to Fri
TABLE#2 (This is what I need to set this format)
OrderID InStock Mon Tues Wed Thurs
Friday
1 Product A Yes No No
No No
1 Product B No No Yes
No No
1 Product C No No No
No Yes
1 Product D same thing with Product A, B C
1 Product E .....
2 Product A No Yes No
No No
2 Product B No No No
No Yes
2 Product C No No No
Yes No
2 Product D same thing with Product A, B C
2 Product E
Your help would be much appreciated. I'm having a nightmare with 850
records that I'm trying to convert from Table #1 to Table #2.
I don't know where to start. I would be appreciated your help. I
have approximately 850 records (Table 1)
Table 1 has 100 Field Names that have a product name but should be a
value not the field name. It is very difficult to explain but I will
make it an example:
I want to create a button to do the work from Table #1 to Table #2.
When I import the data from excel spreadsheet to Access XP and Product
A, B, C become Label but it should be value than label. Table #1 is
the same format as excel spreadsheet.
TABLE #1
OrderID Product A Product B Product C........... up to 100
1 Mon Wed
Fri Mon to Fri
2 Tues Fri
Thurs Mon to Fri
TABLE#2 (This is what I need to set this format)
OrderID InStock Mon Tues Wed Thurs
Friday
1 Product A Yes No No
No No
1 Product B No No Yes
No No
1 Product C No No No
No Yes
1 Product D same thing with Product A, B C
1 Product E .....
2 Product A No Yes No
No No
2 Product B No No No
No Yes
2 Product C No No No
Yes No
2 Product D same thing with Product A, B C
2 Product E
Your help would be much appreciated. I'm having a nightmare with 850
records that I'm trying to convert from Table #1 to Table #2.