Report based on 3 Tables

  • Thread starter Thread starter Kevin Baker
  • Start date Start date
K

Kevin Baker

Hi Everyone!

I have a mdb with 3 tables.. Purchasemaintbl, receipttbl, and adjustmenttbl.
Purchase is the main table with receipt and adjustment being the children..
I'm trying to build a report that would look like the below:





Receipt Info

Adjustment info

Invoice


Date
PO Number
Vendor
Date
Number
Amount
Date
Number
Amount
Number
Amount

1/1/2005
5001-9700
Eurpac
1/2/2005
1
$ 100.00



25350
$300.00




1/3/2005
3
$ 200.00






1/2/2005
5002-9701
S&K Sales
1/3/2005
2
$1,000.00
1/4/2005
4
$500.00






1/4/2005
5
$ 750.00









1/5/2005
6
$ 800.00








Notice how the first 3 fields are blank when there is more than one
receipt...

Any help??

Thanks,
Kevin
 
Kevin said:
Hi Everyone!

I have a mdb with 3 tables.. Purchasemaintbl, receipttbl, and adjustmenttbl.
Purchase is the main table with receipt and adjustment being the children..
I'm trying to build a report that would look like the below:





Receipt Info

Adjustment info

Invoice


Date
PO Number
Vendor
Date
Number
Amount
Date
Number
Amount
Number
Amount

1/1/2005
5001-9700
Eurpac
1/2/2005
1
$ 100.00



25350
$300.00




1/3/2005
3
$ 200.00






1/2/2005
5002-9701
S&K Sales
1/3/2005
2
$1,000.00
1/4/2005
4
$500.00






1/4/2005
5
$ 750.00









1/5/2005
6
$ 800.00








Notice how the first 3 fields are blank when there is more than one
receipt...

Any help??
Click to expand...


So what kind of help are you looking for?

If you want those blanks set the text boxes for those fields
so their HideDuplicates property is Yes.

If you want to get rid of the blank spaces, use Sorting and
Grouping (View menu) to group on the POnumber field. Move
the PO info text boxes to the POnumber group header section.
 
Back
Top