Report

[jimmy]

hi, everyone

i have a problem

table a

inv# amount
1 1
2 3
3 3.1
4 2.1

table b (paid)

inv# paidamount
2 1
4 2

i want to create a report which can list out the all invoice with paid
invoice number and paidamount

i tried to create a report but it just only list out the invoice, paid
invoice and paidamount (it was created to relationship between table a and
table b)


please help
thanks
jimmy

 

[Duane Hookom]

You have provided table a and table b but not the expected display of your
report. Could you type the expected display based on your sample records?

 

[jimmy]

hi, duane

thank for your quick reply

the expected result is as below

inv# amount pinv# paidamount
1 1 n/a or blank n/a or blank
2 3 2 1
3 3.1 n/a or blank n/a or blank
4 2.1 4 2

please help

thanks
jimmy

 

[Duane Hookom]

Create a query based on the two tables. Join the Invoice Number fields and
set the join properties to include all records from table a and records from
table b where they match.

 

[Jw]

hi, duane

thank for your reply

in fact, i already created a query between table a and table b but the
result list out all records based on table b. some records are missed
because those are not shown on the table b.

i wish that the report can list out all records based on table a's records
to match in the table b, how to do it.

thanks
jimmy

 

[Duane Hookom]

If you view the SQL of your query, do you see a phrase like "LEFT JOIN" or
"RIGHT JOIN"? Please paste your SQL view into a reply if you can't figure
this out.