Query not returning any records.

[rebfein]

Hi there, its me again, with yet another question...

I registered an earlier question today, in the Reports venue, about using the same report for separate queries all basically structured the same (fields, tables, etc.).

So I copied the original query and replaced the company name and the query comes up empty. I checked the tables used and the information is there. The criteria is the exact same, but for the company name.

Here's the original Design view:


Here's the returned values:

Here is the edited Design view:


Here is the edited returned values:


What am I doing wrong????

Thank you in advance,

Rebecca Feinstein

[Bulzie]

Check that the criteria values on the 2 columns, do they match values in that field in the table? Soimetimes you can spell them wrong. If all is good, then it is your links. Since you have it set to InnerJoin, if either table does not have a matching record, it will return no data. Change the joins to both Left Outter (arrow pointing to right) on both links and see what it shows you. Or another test, take out one of the tables, see if it returns data to try to pinpoint the issue.

[davegri]

For KGS_PN

Like "IC" & "*"

You don't need the first wildcard *
You don't have any square brackets in the fields, so you will never get a match.

[ssanfu]

In the first column of the query, the top query (works) you have "INTE".
In the second version of the query, the bottom query (doesn't work) you have "=DIIN".

Try removing the "=" sign......


Also, it looks like you have a design problem - table "TBL_KGSComponentsListofAllMfrs" is not normalized.... (repeating fields)