access2003 returns zeros instead of valid data on SIMPLE query.

[Phil]

Simplist query imaginable. 1 table, select three fields from that
table. No criteria, no joins, no nothing. One of the fields is a long
integer field, but only contains numbers up to three digits.

I run this query, and it returns zero for every single record. this is
NOT the actual data. It is bogus. If I open a table view, I see the
data, so ODBC is working.

Even worse? I IMPORT the table so it is no longer using ODBC. I can
verify that the data came over properly. Yet I open a query to THAT
table, choose three fields and run, and opnce again, I get all zeros.

Any ideas as to why? How do I fix this thing?

 

[Guest]

If you would convert your query to an SQL statement and post, that might help.

 

[Phil]

SELECT item1.item_id, item1.short_desc, item1.type_id
FROM item1;

Like I said, VERY simple.

 

[ja]

post the sql translation and we'll help you better.

 

[Phil]

I did, but here it is again.

SELECT item1.item_id, item1.short_desc, item1.type_id
FROM item1;