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

's Computer Specifications

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

's Computer Specifications

On Mon, 20 Apr 2009 10:47:28 -0400, "JP" <(E-Mail Removed)> wrote:

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

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

John W. Vinson [MVP]

's Computer Specifications

>
> Try using the Caption property of the field instead of the fieldname.
> Periods
> are simply not allowed in fieldnames.
> --
>
> John W. Vinson [MVP]

Thanks!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Access won't let me put a period in a query heading	BruceM	Microsoft Access	0	20th Apr 2009 04:23 PM
Query for UK Financial period	DaveTheRave.NET	Microsoft Access Queries	1	24th Sep 2007 03:57 PM
Query for time period	=?Utf-8?B?V2lsZXlj?=	Microsoft Access Queries	1	5th Jul 2006 06:03 PM
Query for time period	=?Utf-8?B?V2lsZXlj?=	Microsoft Access Queries	1	22nd Jun 2006 07:38 PM
finding if a period falls within a period in access 2000	=?Utf-8?B?Y2RwZWE=?=	Microsoft Access Queries	1	18th Oct 2005 04:20 PM