Thanks! I have forwarded the email with the screen prints with sample data.
Also have the formula in the access query so you can see. I just don't know
why excel will not allow me to query as the query works fine in access. I'm
using this data to create kanban pull sheet to suppliers. The first data
stream that I will read from a barcode has the part number(space) their
control number(space) and the qty. I use this to give them feedback as to
what material I consumed for the consignment material to bill.

"Martin Fishlock" wrote:

Hi terry,

You can send them to me martin_fishlock @ yahoo . co .uk (with no spaces)


--

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"TerryD" wrote:

I get this error as I am trying to query in excel from access database. The
query works fine in access that is use to break down the data. Why will it
not come down to excel? I have all of the date particulars ( screen prints in
outlook and could send to someone wher you can see more information.