misternumbertwo
Registered User.
- Local time
- , 07:47
- Joined
- Dec 29, 2008
- Messages
- 11
Guys,
I need to find a way to convert results of a single column query to headers of a table. Here's a gist of the situation:
I am doing a database for Freight Rates but the fields and number of fields vary upon each lane. Now I need to find a way to pull information out of different tables; tbl_OriginCharges, tbl_DestinationCharges and tbl_FreightCharges, all 3 have 50 fields on it with Field names (F1...F50). I also have a separate table for the headers which i want to pull the table headers from.
So, is there a way to join all these four tables and pull it as such that F#'s will be replaced by the header names in the header table?
Any suggestion will be highly appreciated.
I need to find a way to convert results of a single column query to headers of a table. Here's a gist of the situation:
I am doing a database for Freight Rates but the fields and number of fields vary upon each lane. Now I need to find a way to pull information out of different tables; tbl_OriginCharges, tbl_DestinationCharges and tbl_FreightCharges, all 3 have 50 fields on it with Field names (F1...F50). I also have a separate table for the headers which i want to pull the table headers from.
So, is there a way to join all these four tables and pull it as such that F#'s will be replaced by the header names in the header table?
Any suggestion will be highly appreciated.