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 >

RE: Access field names with spaces

2000-07-20 Thread David Gassner
t; > > Tim Claremont > Xerox Corporation > > > > -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
ssage- 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]>

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 Allen G
rename them! =-) - Original Message - From: "Claremont, Timothy S" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, July 20, 2000 1:03 PM Subject: Access field names with spaces > Can anyone tell me the secret to working with Access field names that have > spaces in them? >