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

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."
 
J

John W. Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DoCmd.TransferText does not export field names correctly 1
DoCmd.TransferText issue 3
Headings to rows in a query 4
Basing Report on Crosstab 3
Export large query from Access 3
Unable to delete linked table in Access 2007 20
"is not a valid name. Make sure... 1
Query with multiple tables won't let me change data. 2

Top