WEIRD Select Query Problem

[russi]

Don't laugh, but I am using Access 97 on XP machine at work.

I have a database with 2 files, 1 of which I imported from another one.

I have attempted to do a Select Query on a text field. I know that there are 1,000s of matches, but cannot get any results when I set the query based on that field. (Something I do successfully with tables, everyday.)
:banghead:

Why? Please help...

Russ

 

[TexanInParis]

Russ-

It would help to see the SQL of your query and perhaps a small sample of the rows you think your predicate should match.

 

[RainLover]

Do you have Look Ups in your Tables.

Nothing wrong with 97.
I much prefer it to 2007 or 2010.

 

[russi]

Hi.
Unfortunately, as the data is confidential gov't. related, I canot send you data from the tables.
I checked and there is no Lookup.

Other ideas?

Russ

 

[TexanInParis]

But you could still post the SQL, right?

Open the query in Design view. Switch to SQL View and copy and paste the text into a reply.

 

[russi]

Hi. Per your suggestion, I am posting the SQl from 2 variations that I have tried. Please know that when I manually check the tables, most records' client names exist in each table. Same field type/information in Design View. Plus the names themselves, in Datasheet View.
(By the way, I appreciate your efforts.)

Russ

 

[russi]

Sorry. here are the SQLs from the 2 variations.

SELECT WIA.Field202, WP.Field81
FROM WIA LEFT JOIN WP ON WIA.Field202 = WP.Field81;

SELECT WIA.Field202, WP.Field81
FROM WIA INNER JOIN WP ON WIA.Field202 = WP.Field81;

Russ

 

[TexanInParis]

Well, that's interesting. You get no results from either query? With an INNER JOIN, you should get rows that match in both tables. With a LEFT JOIN, you'll get all the rows from the table on the "Left" (WIA) and any matching on the "right". If you're getting no matches, then there may be extra blanks in one of the two fields.

 

[MSAccessRookie]

Is the NATURE of the data confidential, or only the content? If the NATURE is not confidential, then it could be possible to show the design for the two Tables. It might also be possible to create a test dataset (using fake information that fairly represents the actual data) and display screenshots of the results. Either or both of these would go a long way towards a solution.

-- Rookie

 

[RainLover]

In the Query Design click on the Join line. Try all three options.

Just a stab in the dark here.