spaces in column names

  • Thread starter Thread starter daniel mcgregor
  • Start date Start date
D

daniel mcgregor

I have an ASP application which uses an access DB for
queries etc. however the DB was built by another
application and so i can't change the columns name (to
make 'Email Address' the same as 'EmailAddress' on the DB.
the query is like

SELECT Person.* FROM Person WHERE Person.Email Address
= "(e-mail address removed)"; how can i get the query to ignore
or bypass the space in the Email Address column?
Thanks for any help
Dan
 
Back
Top