Excel Query fails to include data?

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

Guest

Doing an Excel to Excel query, that is simple enough that the wizard is
adequate. One of the source fields (Price) contains both numeric data, and
when such data is not avaiable, a "-". No filters are applied to the price
field.
In the wizard, preview lists only one item, the "-" unlike the other fields
that preview as a complete list. The query correctly returns all the field
values except price, which except for the colum label, is all blank.
Shouldn't query return the price value even if it is text?
Thanks for any suggestions.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO with mixed data 2
Can't create a report from my query in Access 1
Using Query to return data from SQL database 3
How does MS Query assign data types? 1
Access Access Report Works on One Machine but not Another 3
Macro to stop data entry errors 1
Excel query not responding 1
Data too large for Excel, need to query Access data for results 8

Back
Top