MS QUERY COL HEADINGS

D

don

I have a query from Excel into a SQL2000 Database. I have some calculated
fields like datepart and also some combined fields.

The resultant query is retrieved without headings on calculated Columns.
Also using a field with AS statement does not work and after saving the
query and accessing again, the AS portion is gone.

Example: I enter: ihead.invoice_no AS 'Invoice',
save query, query returns column with heading of invoice_no.

Look at SQL again and it shows ihead.invoice_no ,

Just putting a space where the AS 'Invoice' was.

Probably a flag or setting, can't find in help, so asking group.

Thanks.

Don
 
Top