openquery command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to run a select query using VBA. I'm using a function within the
query so that the query results are based on the value returned by the
function. It runs ok as long as the value returned by the function is a
single value. However, the query does not return any records if the value
contains a composite string such as "Core" or "NCB" or even "like "*'". I
can do the same action if I use the openreport command because it allows some
additional arguments. Could someone tell me if there is a solution to this
without having to create a report. Thanks.
 
PC said:
I'm trying to run a select query using VBA. I'm using a function within the
query so that the query results are based on the value returned by the
function. It runs ok as long as the value returned by the function is a
single value. However, the query does not return any records if the value
contains a composite string such as "Core" or "NCB" or even "like "*'". I
can do the same action if I use the openreport command because it allows some
additional arguments. Could someone tell me if there is a solution to this
without having to create a report.
Click to expand...

I'm pretty sure there is a way, but we can't figure it out
until we get more information about what the function might
return and see the query's SQL statement.
 
Back
Top