while this is the best answer, you can enclose them in ['s. (eg, [field 1],
[field 2].)
Chris Olive,
DOEHRS Website Administrator
-Original Message-
From: Allen G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 20, 2000 2:10 PM
To: [EMAIL PROTECTED]
Subject: Re: Access field names
: Allen G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 20, 2000 2:10 PM
To: [EMAIL PROTECTED]
Subject: Re: Access field names with spaces
rename them! =-)
- Original Message -
From: "Claremont, Timothy S" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 20, 20
Message-
From: Allen G [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 20, 2000 2:10 PM
To: [EMAIL PROTECTED]
Subject: Re: Access field names with spaces
rename them! =-)
- Original Message -
From: "Claremont, Timothy S" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
SELECT `Bad Guy` AS Good_Guy .
Use Bck-ticks to enclose the offender.
In the long run you should change the names if you ca.
At 2:03 PM -0400 7/20/00, Claremont, Timothy S wrote:
Can anyone tell me the secret to working with Access field names that have
spaces in them?
Thanks,
Tim
4 matches
Mail list logo