How to insert new fields into a table (auto)?

[DBLoser]

I've exported and manipulated data from another system into a table with 3 fields, GLDEPT, CHART, and YTD. I need to add more fields (with recurring default values) to each record so that I can export the table into a text file. How can I add the fields (through code)?

Right now it looks like:
GLDEPT CHART YTD
100 100000 100.00
100 100100 0.00
200 100000 3000.00
200 440000 70.00

I want the end result, once exported to look like:

LABEL1 LABEL2 GLDEPT LABEL3 CHART YTD
W_GTD_TB ACTUAL 100 USD 100000 100.00
W_GTD_TB ACTUAL 100 USD 100100 0.00
W_GTD_TB ACTUAL 200 USD 100000 3000.00
W_GTD_TB ACTUAL 200 USD 440000 70.00

The LABELx columns will always have the same data.

Thanks,

Bruce Brannan

 

[PHV]

Instead of exporting a table, simply export a query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DBLoser]

I can export a query but how do I insert additional (new) fields?

Bruce

 

[DBLoser]

Thanks PHV for the tip. I just figured it out. Through a query a added a field called LABEL1:"W_GTD_TB" and it autofills that down every record.