Link to home
Start Free TrialLog in
Avatar of Harsh Kumar
Harsh KumarFlag for Denmark

asked on

SQL query and VBA

Hi guys, Im trying to figur out a Query and im not that strong in SQL querys at all.. please advise

From Excel with a Ado. connection ( which works just fine) i need something like:

Select * FROM Tblname WHERE [namecol] = "'" & Name & "'" AND WHERE [Workcol] = "'" & work &"'"

Then msgbox result

Please advise

Thank you in advance
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Harsh Kumar

ASKER

Thanks Guys, i found out that I was right from start but VBA has a bug when counting ther recordset :)