change the caption of a query column using VBA? 1

[JOD59]

Is there a way to change the caption of a query column using VBA?

 

[Trevil]

How about 'Select flda as Product from tableA ...'

Code: Where the vision is often rudely introduced to reality!

 

[JOD59]

Trevil, thanks for your response, but I'm not quite sure what you mean. I'm fairly new to VBA. Could you show me a sample of code? Thanks for any help

 

[Trevil]

The following is what you proibably have:
SELECT tbl1.fld1, tbl1.fld2, tbl1.fld3
FROM tbl1
ORDER BY tbl1.fld1;

To rename the columns use:
SELECT tbl1.fld1 AS Customer, [:fld2] AS City, tbl1.fld3 AS State
FROM tbl1
ORDER BY tbl1.fld1;


Code: Where the vision is often rudely introduced to reality!

 

[JOD59]

Thanks Worked like a charm!!!