cardgunner
Registered User.
- Local time
- Today, 01:00
- Joined
- Aug 8, 2005
- Messages
- 210
Good Afternoon.
I'm trying to create a string of text that has two fields and 5 records. I have two tables. The first with all the specifc info on(lot #, Serial Number, manufacture, and etc.). My second table has the equipments specific descriptions. First line is for instance [26124][168][hp]. the 2nd record is [26124][31590lbs.][Oper. Weight] and such. I want to create a query where my first field is [26124]and then ["168"& "hp"& ", " & 315920lbs. " & " Oper. Weight"] My actual table and field names names are ttscfg200100.t_clot and ttdext816100.t_clot, ttdext816100.t_spec, ttdext816100.t_dsca. What I'm hoping to achieve is shortening my time involved with getting to the printers my equipment descriptions. Any help on the sql of this?
I'm trying to create a string of text that has two fields and 5 records. I have two tables. The first with all the specifc info on(lot #, Serial Number, manufacture, and etc.). My second table has the equipments specific descriptions. First line is for instance [26124][168][hp]. the 2nd record is [26124][31590lbs.][Oper. Weight] and such. I want to create a query where my first field is [26124]and then ["168"& "hp"& ", " & 315920lbs. " & " Oper. Weight"] My actual table and field names names are ttscfg200100.t_clot and ttdext816100.t_clot, ttdext816100.t_spec, ttdext816100.t_dsca. What I'm hoping to achieve is shortening my time involved with getting to the printers my equipment descriptions. Any help on the sql of this?
