In a Query, first record shows all fields, second record only shows some fields.

[Travis]

HI.



I'm brand new to this stuff.

I have created two tables.

I have created a query that needs fields from both tables.

Since I'm very new to this, the first table has only 13 records in it, and the second table only has two records in it. (for now!)

When I run the query, the first record shows all fields. But the second record only shows fields from one table.

I would kinda understand if neither record in the query showed fields from both tables, but it sure beats me why one record shows all fields from both tables and the other record only has fields from one table.

Any help you can give this newbie is GREATLY appreciated!!

Travis

[ranman256]

we need to see the query. could be different reasons.

[Travis]

Thank you. Um, I'm sorry to say that my intelligence level is only slightly above that of a rock.

How do I show you the query? I tried copy/paste and I managed to copy the results table, but I suspect that what you want to see is the design view. I can't figure out how to show you that. Please help!!

THANK YOU.

[Welshgasman]

Check your join and the values of the joined fields?

[ranman256]

select the query, click DESIGN,
take a photo, or click SQL
post either.

[Travis]

Two overlapping screenshots of the design view, and the results.

Again, any help you can give is very much appreciated!!

select the query, click DESIGN,
take a photo, or click SQL
post either.

[Travis]

A photo of the right side of the design view of the query:

[Travis]

How do I mark this SOLVED!! I'm embarrassed to tell you the mistake......I have a field for LName and a field for FName. On one record, I got the names switched!! 40 Lashes with a wet noodle for me!! Seriously, sorry to have wasted your time.