Duplicate informtion on multi-table Query

I'm new at this and don't understand what's happening or how to fix
it!

I have 4 tables: Student (6 fields), Charges (3 fields), Payments,
(3fileds), and Address (4 fields).
All Tables have student ID_Number for each set of data. Charge and
Payment have Date and Amount.
One main form (Student info) with 2 subforms (Charges and Payments).
This is for input.

The problem is that when I create a query for the student that shows
the Charges and Payments then I get repeated payments for each Charge
entered.

I need to create a report that prints out a correct statement.

What I get (from the Query (and the report prinout) looks like this:

ID: 12345 Student: John Doe
\Charges: 10/10/07 $4.00 Payments: 10/12/07 $3.00
10/15/07 $8.00
10/20/07 $6.00

10/12/07 $3.00

10/20/07 $6.00
Repeated data - Help Anyone!???

Re: Duplicate informtion on multi-table Query

suggest you try a report based on tblStudent (or a query based on tblSTudent
and tblAddress, if you wish), with subreports based on tblCharges and
tblPayments respectively. link the main report and subreports by the student
ID number.

hth


"Deac" wrote in message
news:1194203739.337835.132350@57g2000hsv.googlegroups.com...
> I'm new at this and don't understand what's happening or how to fix
> it!
>
> I have 4 tables: Student (6 fields), Charges (3 fields), Payments,
> (3fileds), and Address (4 fields).
> All Tables have student ID_Number for each set of data. Charge and
> Payment have Date and Amount.
> One main form (Student info) with 2 subforms (Charges and Payments).
> This is for input.
>
> The problem is that when I create a query for the student that shows
> the Charges and Payments then I get repeated payments for each Charge
> entered.
>
> I need to create a report that prints out a correct statement.
>
> What I get (from the Query (and the report prinout) looks like this:
>
> ID: 12345 Student: John Doe
> \Charges: 10/10/07 $4.00 Payments: 10/12/07 $3.00
> 10/15/07 $8.00
> 10/20/07 $6.00
>
> 10/12/07 $3.00
>
> 10/20/07 $6.00
> Repeated data - Help Anyone!???
>