User Profile

Collapse

Profile Sidebar

Collapse
CAPETOWNANDRE
CAPETOWNANDRE
Last Activity: Aug 9 '09, 09:39 PM
Joined: Aug 9 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • CAPETOWNANDRE
    replied to Parameter Using In List In SQL Qualifier
    in Access
    Yep, that will work , but when you want to send the values as a parameter
    MYPArm = " 'NJ','PA','WA ' "

    select * from Employees where employees.regio n in ([myparm]);

    It wont work
    See more | Go to post

      Leave a comment:

    • CAPETOWNANDRE
      started a topic Parameter Using In List In SQL Qualifier
      in Access

      Parameter Using In List In SQL Qualifier

      Hi

      I am using VBA to execute access queries, all works fin but cannot pass in more that one value in my parameter#

      Select * from table where myvalue in ([myparm]);

      this workd great for a single value : value01
      But will not accept : value01,value02 ,Value03

      I have tried many combinations of single and double quotes but with no sucess
      See more | Go to post
      No activity results to display
      Show More
      Working...