Excel Query not returning numeric values

  • Thread starter Thread starter Tammy Baker
  • Start date Start date
T

Tammy Baker

Iam having problems with data in a column that has both
alpha and numeric data. The query is pulling in the
alpha values but not the numeric values. The field for
the record is blank if the value is numeric???? Any
ideas????

I accidently poasted this to the wrong newsgroup the
first time. Is there any way to delete the other entry?
 
What is the query - Give us some more details and an example of the data.

No you cannot delete the other note - forget it unless you want to post another to it saying that
you have taken the problem to the correct group, which might save someone some time trying to
understand it for nothing.
 
I created a query to bring info from an excel spreadsheet
to a template. One of the fields thta is brought in is a
field listing color codes. Some of the codes are alpha
and some are numeric
Examples:
RED
NVY
010
325
659

All of the codes that are alpha are being pulled into the
template but the codes that are numeric are not???
The query is pulling in dates and other values fine.

Thank you for your time!

-----Original Message-----
What is the query - Give us some more details and an example of the data.

No you cannot delete the other note - forget it unless
Click to expand...
you want to post another to it saying that
you have taken the problem to the correct group, which
Click to expand...
might save someone some time trying to
 
Back
Top