Hello - I'm using an MS Query SQL statement to gather records from an Access table. The table name varies depending on what I'm doing, so I'd like to pass the table name and have it select records from that table. Here is the command I have so far:
SELECT Owners.DisplayName, Owners.Owners FROM `C:\Groups.accdb`.Owners Owners WHERE (Owners.DisplayName='InputRecords') What I want to do is change 'InputRecords' to a variable name that's been predefined. How can I define a variable and then pass it to the SQL statement in Excel MS Query? Thank you! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe