Unknown Qty of Items on Report

  • Thread starter Thread starter Simon Harris
  • Start date Start date
S

Simon Harris

Hi All,

I am trying to create an invoice report in Access 2002 - I have built a
basic report, driven from a query which displays customer address, invoice
number, etc - This works Ok.

What I now need to do is add the actual items to the invoice (Stored in
another table/query)

How do I go about adding items where the qty is unknown? I am quite
knowleagble in Access/VBE so probably just need a kick-start!

As ever, much appreciated.

Regards,

Simon.

--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
 
Simon Harris said:
Hi All,

I am trying to create an invoice report in Access 2002 - I have built a
basic report, driven from a query which displays customer address, invoice
number, etc - This works Ok.

What I now need to do is add the actual items to the invoice (Stored in
another table/query)

How do I go about adding items where the qty is unknown? I am quite
knowleagble in Access/VBE so probably just need a kick-start!

As ever, much appreciated.
Click to expand...

The usual approach would be to use a subreport or base the report on a
query containing both tables and then use the Grouping/Sorting tools of the
report to place the Items in the detail section with header data in a group
section.
 
Thanks Rick,

I've have the report working now, but when I view it, there is a big white
gap between the detail and the footer sections, even though I have dragged
the two sections close together.

In design view, it looks something like this:


----------------------------------------
Header
Customer address etc


----------------------------------------
Detail - Invoice Items, repeating
----------------------------------------
Footer
Payment terms, how to pay etc
----------------------------------------


When I view...


----------------------------------------
Header
Mr Fred Smith
123 Something Road
Some where
----------------------------------------
Item 1 12 £25
Item 2 3 £12





<<<Why this white space???>>>
 
Simon Harris said:
Thanks Rick,

I've have the report working now, but when I view it, there is a big white
gap between the detail and the footer sections, even though I have dragged
the two sections close together. [snip]
Click to expand...

Ordinarily, white space in preview is caused by white space in design view.
Try temporarily making the background color of each section different and
then preview it again. At least that will tell you which section is
producing the (now non-white) space.

Also check your CanShrink CanGrow properties for each section.
 
Back
Top