MS Access/SQL issue

Results 1 to 2 of 2

Thread: MS Access/SQL issue

  1. #1
    Join Date
    Dec 1969

    Default MS Access/SQL issue

    Hello,<BR>I have a table with a field name Tier-ID<BR><BR>I am using this code:<BR><BR>strSQL = "SELECT * FROM tblData " & _<BR> "WHERE tblData.Tier-ID IN(" & strCriteria & ");"<BR><BR>My issue is the hyphen in Tier-ID, Access is not reading this correctly.... I cannot remove the hyphen from Tier-ID because the table data is coming from an external source.<BR><BR>Can I can get Access 97 to read the Tier-ID with the hyphen?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: MS Access/SQL issue

    strSQL = "SELECT * FROM tblData " & _<BR>"WHERE [tblData].[Tier-ID] IN(" & strCriteria & ");"

Posting Permissions

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