Thread: MS Query report
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andyp andyp is offline
external usenet poster
 
Posts: 2
Default MS Query report

I would like to use Excel & MS Query to return data from a database. I have
built a query that works, based upon a static 'contains' criteria - a like
'%<criteria%' statement, but what I would like to do is to take the
'%<criteria%' from a cell within the excel worksheet. I can return data
using the equals command, but cannot get the contains statement to work

Can this be done without the use of macros or VB??

Please Help!!!!!