Not a valid alias name

Results 1 to 2 of 2

Thread: Not a valid alias name

  1. #1
    Mark Guest

    Default Not a valid alias name

    Why do I keeep getting this error message in Access 2000. I do not understand it&#039;s meaning, are their any fixes or ways around it. Usually this occurs when a query queries a query to return new records or values. I did not get this in the 97 version.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Not a valid alias name

    That would make me think that you&#039;ve defined an alias for a table or column that Access isn&#039;t happy with, probably because it&#039;s a reserverd word. For example, in this query:<BR><BR>SELECT sender AS from FROM email<BR><BR>the column "sender" is aliased as "from". Since "from" is a reserved word, this query is invalid and would probably throw the error you describe.<BR><BR>Dunc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts