Web Development

Ask something
Discussion Locked

An Easy One? Access 97

0 helpful
3 replies

by mra2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a report which shows dependent records. On the same report I need to know how many parent records there are so I can charge each parent record a fee. Right now the fee is being INCORRECTLY multiplied by the number of child records.

3 replies

by dklippert

Create a Query using the Parent and Dependent tables.
Join the two table by there common or Primary Key.
Right click the Join line and choose Join Properties.
Choose the Join Property that includes All records from Parents and only those record from test where the fields are equal.

by mra2

Doug,
GREAT ANSWER!!! It worked Well!!!!! Thanks very much...... Alan
mra2@mindspring.com

This discussion is closed to new replies.