Report

  • Thread starter Thread starter jimmy
  • Start date Start date
J

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
 
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?
 
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
 
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.
 
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
 
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.
 
Back
Top