Report

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?

--
Duane Hookom
MS Access MVP


"jimmy" wrote in message
...
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

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" ¦b¶l¥ó
¤¤¼¶¼g...
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?

--
Duane Hookom
MS Access MVP


"jimmy" wrote in message
...
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

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.

--
Duane Hookom
MS Access MVP


"jimmy" wrote in message
...
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" ¦b¶l¥ó
¤¤¼¶¼g...
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?

--
Duane Hookom
MS Access MVP


"jimmy" wrote in message
...
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

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" wrote in message
...
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.

--
Duane Hookom
MS Access MVP


"jimmy" wrote in message
...
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" ¦b¶l¥ó
¤¤¼¶¼g...
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?

--
Duane Hookom
MS Access MVP


"jimmy" wrote in message
...
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

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.

--
Duane Hookom
MS Access MVP
--

"Jw" wrote in message
...
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" wrote in message
...
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.

--
Duane Hookom
MS Access MVP


"jimmy" wrote in message
...
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" ¦b¶l¥ó
¤¤¼¶¼g...
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?

--
Duane Hookom
MS Access MVP


"jimmy" wrote in message
...
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