Make table

[jaabaar]

Query type: Make Table.
It generates the make table using the true field names instead of using Caption as field name. For my need it must use Caption as field name. The starange thing is i have 5 make table queries and only one uses Captions as field name.

Is there any way to make caption as field name.


Thanks

 

[madonnac]

put the name you want the column to have after the field you retrieve

example:

SELECT SiteNames.ID AS [Number], SiteNames.SiteName AS site
FROM forecasting_SiteNames;

this will have the columns labelled "Number" and "Site" instead of ID and SiteName