Access won't let me put a period in a query heading

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

SELECT Cost As [Total.Cost]
FROM tblDetail

I need to export a query to a csv file with periods in some of the column
headings. However, Access won't allow this. The message states "Total.Cost
is not a valid name make sure that it does not include invalid characters
and that it is not too long."
 
SELECT Cost As [Total.Cost]
FROM tblDetail

I need to export a query to a csv file with periods in some of the column
headings. However, Access won't allow this. The message states "Total.Cost
is not a valid name make sure that it does not include invalid characters
and that it is not too long."
Click to expand...

Try using the Caption property of the field instead of the fieldname. Periods
are simply not allowed in fieldnames.
 
Back
Top