deepanadhi
New member
- Local time
- Today, 06:39
- Joined
- May 14, 2012
- Messages
- 7
Hi All,
I have a table with 60+ fields, which includes around some 30 dates also as field names.
Now my requirement is that i need to move those date field-names alone into another table or a query..?
Ex : Table
How to do this..
Thanks in Advance,
Deepan M
I have a table with 60+ fields, which includes around some 30 dates also as field names.
Now my requirement is that i need to move those date field-names alone into another table or a query..?
Ex : Table
Code:
Field 1 | Field2 | FIeld3(date) | Field4 (Date) | and so on...
The new table should contain
Dates (Column Name )
-----
Field3(Date)
FIeld4(Date)...
How to do this..
Thanks in Advance,
Deepan M