Count records in query with joined table

[RonMcIntire]

All:
I can write a query with the "group by/count" total that outputs the number of records for a value in the table but,
can I add a joined table to the query so I can add other fields to the query output?

If so how? I have tried but I get only a count of one for each record.

Ron

 

[Andrzejek]

Could you show a sample of the data and the expected outcome?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[RonMcIntire]

Thanks for your help anyway. I think I have it figured out.