RE: Access field names with spaces

2000-07-20 Thread Olive, Christopher M Mr USACHPPM
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

RE: Access field names with spaces

2000-07-20 Thread Claremont, Timothy S
: 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

RE: Access field names with spaces

2000-07-20 Thread David Gassner
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

Re: Access field names with spaces

2000-07-20 Thread Dick Applebaum
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