Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Wyverrn
-
Multiple Parameters on the same field in a querytable
So should concatenate the variable directly into the SQL Statement rather that creating parameter objects. Seems easy enough. Is there any purpose to the parameter object then? It seems to be needlessly complex, especially considering the method you suggested seems so much easier. Thanks a...- Wyverrn
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Multiple Parameters on the same field in a querytable
Hello, I am trying to write a query macro in Excel to query off of an SQL database. What I cannot seem to figure out is how to have a parameter to return a range of values(like between 2 dates) MSQuery will not work for me as I will need multiple tables and left outer joins, something...- Wyverrn
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
