weird query question

[pwicr]

As you can see with the attached photos, if I just query the serial numbers and dealers everything comes up exactly as it should...

If I add the second table...I get the individual serial numbers but all the same dealers.:banghead:

I know I'm overlooking something small but can't figure it out.

 

[Guus2005]

you might want to check if DEALERS contains MCMAHONS RV with all these serialnumbers. Which means that there is nothing wrong. Linking to the table tblDealers just sorts the result.

The number of records are not the same because some DEALER records don't have a match in tblDealer.

HTH

 

[pwicr]

you might want to check if DEALERS contains MCMAHONS RV with all these serialnumbers. Which means that there is nothing wrong. Linking to the table tblDealers just sorts the result.

The number of records are not the same because some DEALER records don't have a match in tblDealer.

HTH

unfortunately that isn't the case here. All the records are showing the same dealer and all the different dealers are in tblDEALERS as DEALERBUY is looking up from that table.

this is frustrating as until I get this figured out my report won't work. I changed one little thing and BOOM! ARGH!

 

[Guus2005]

Can you post a sample database?