Hi all,

I have an excel spreadsheet that is linked to an access query.
The query returns daily revenue info (claim#, product, trade date and
commission.

This works fine but now I have to return only ethanol products. If
I put in the query criteria "Ethanol" I get only ethanol products.
Since there are more than 1 products with the name ethanol in it, I
use Like "*Ethanol*" in the criteria.

In access the query runs fine and will return all records that have
Ethanol in the product name. When I refresh the spreadsheet nothing
is returned.

Is there any reason why no records are returns while is use Like
Like "*Ethanol*"? Also is it possible to pass the date from excel to
the access query to return records for a specific date. Current i only
return records for the current date.

I am posting here but will also post this message in an excel group
since I'm not sure if I need an Access or Excel guru to solve this
problem.

Any help is greatly appreciated,

Joe V

jovi07 (AT) verizon (DOT) net wrote:

You state "In access the query runs fine and will return all records
that have Ethanol in the product name. When I refresh the spreadsheet
nothing is returned."

What do you mean, refresh the spreadsheet? Are you running the query in
Access and expecting the result in Excel?

The query is in an access db and works if I run the query in access.

When the query has "Ethanol" in the criteria, I open the spreadsheet
and refresh it (alt +F5) to get new records that where entered today.
This works fine, but as I stated I need all products with the word
"Ethanol" in it, so I cahnge the query in Access and use in the
criteria Like "*Ethanol*". I then refresh the spreadsheet (Alt + F5).
Instead of getting all records with the word Ethanol in the product, I
get a blank spreadsheet.

This is the 1st time I ever linked a spreadsheet to an access query
but it seems Excel doesn't like it when I use Like "*Ethanol* in the
criteria of the access query.

jovi07 (AT) verizon (DOT) net wrote:
If you use the Excel "Data > Get External Data > Create Query" menu
option you can use MSQuery to build a query on the Access tables.
Instead of using LIKE "*Ethanol*" you'd use LIKE '%Ethanol%' - note the
single quotes and the % wildcard in place of double quotes and the *
wildcard. Using MSQuery usually guarantees you'll get the data w/o
worrying about any Access built-in functions that Excel won't recognize.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

On Apr 20, 5:21 pm, MGFoster <m... (AT) privacy (DOT) com> wrote:

I made the change to use MS Query instead of Access query and its
works prefectly.

Thanks for you help