Go Back   Access World Forums > Search Forums

 
Showing results 1 to 1 of 1
Search took 0.01 seconds.
Search: Posts Made By: Gasman
Forum: Modules & VBA 12-28-2018, 03:39 AM
Replies: 4
Views: 566
Posted By Gasman
Re: VBA SQL using a variable in sql query

You need to concatenate the strings with the variables. I've not done this over two lines so would do

strSQL = "SELECT * FROM [TransTbl] WHERE [TransTbl].[Assoc] = '" & InAssoc & "'"
strSQL =...
Showing results 1 to 1 of 1

 
Forum Jump



All times are GMT -8. The time now is 09:15 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World