I flat-out give up!

[JEB]

OK here is the scenario.

New PC on my desc - new AIX box that I am pulling records from through ODBC

Access 2002

I started to write a query and got strange results. I worked back to one table and one query and I am still getting strange results.

SQL:
SELECT infor400_sadet.prodgrp_sadet
FROM infor400_sadet
WHERE (((infor400_sadet.prodgrp_sadet)="200"));

and the results:
prodgrp_sadet
200
200
200
200
200
210
200
206
200
200
200
200
200
200
550
200
200
200
200
200
200
200
315A

Any ideas would be appreciated.

Jeb

 

[casey]

Is [infor400_sadet.prodgrp_sadet] a string field? If it's not, perhaps leave the ("") out of the Where statement (i.e. WHERE (((infor400_sadet.prodgrp_sadet)=200));

Otherwise, what results would you like to receive?

 

[pdx_man]

Please copy and paste your actual query from the SQL View screen.

What you posted can't be the actual code, 'cause the table and fieldnames would be bracketed if Access had parsed it. What ya got and what ya want may be two different things ...

 

[JEB]

Casey - if I delete the quotation marks I get a type missmatch error.

PDX: This is an exact copy from SQL. I can't figure out how to paste a copy of the design view into this thread.

SELECT infor400_sadet.prodgrp_sadet
FROM infor400_sadet
WHERE (((infor400_sadet.prodgrp_sadet)="200"));

Any other ideas would really be appreciated.

Thanks,
Jeb

 

[pdx_man]

Can you post the DB?

 

[Rob.Mills]

I'm assuming the field is a text field. If that's the case that's why it won't let you take out the quotes.

Try in the where clause:

WHERE (((infor400_sadet.prodgrp_sadet) Like "200"));

 

[JEB]

Rob: It is a text field and changing to "like" did not make a difference.

I have also tried "*200*" and variations thereof and nothing worked.


PDX: I can not post the DB

There are over 459,000 records. I am only pulling 12,000 so the criteria I entered is filtering somehow. I just can't figure out how/why and how to get the records I need.

Thanks for all of you help so far. Any other ideas?

Thanks,
Jeb

 

[pdx_man]

Export the query and a small sampling of the data into another DB and post that.

 

[Pat Hartman]

Refresh your link to the ODBC table. I suspect that something about it has changed since you first linked it.

 

[JEB]

I think it is in the link to the table. I tried the same query on another PC and got the correct results. I am reviewing my network settings to see if something is amiss.

I will keep you updated.

Thanks for the help.

Jeb