You can alias the fields inside each query like this:
Select [Field Name] as FieldName
from [Table Name]
> -----Original Message-----
> From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 20, 2000 11:12 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Access field names with spaces
>
>
> There is nothing I would like more (well..there are a few things) than the
> rename the fields, but when you are connecting to somebody else's database
> you get into political BS!
> There is an article in the current issue of ColdFusion Advisor,
> but I can't
> locate the issue, and you can't get to it online without your username and
> password!
>
> Grrrrr...having the answer, but not being able to get to it is worse than
> not having a clue!!!
>
> Tim
>
> --------------------------------------------
> 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 with spaces
>
>
> 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?
> >
> > Thanks,
> > Tim
> >
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------
> ----------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
