Can you qury on a query in VBA and filter in the VBA for a cleaned up output?

[mackyrm]

Can you query on a query in VBA and filter in the VBA for a cleaned up output?

If anyone can advise with a VBA-SQL example, appreciated.

Thanks.

 

[Minty]

Yes you can.

sSql = "SELECT * FROM qryYourQUery "
sSql = sSql & " WHERE add your criteria in here"

 

[mackyrm]

Thanks Minty, I will give this try.