Multiple records needed in report detail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a report that has anywhere from 1 to 5 records in the detail section at a time, the number varying depending on the value of one particular field. e.g. Between 1 and 5 adjacent records in the table have the same invoice# and are entries on an invoice that the report generates. I assume this can be done, but I have no idea how (with or without using VBA code)

ctda
 
ctdak said:
I need to create a report that has anywhere from 1 to 5 records in the detail section at a time, the number varying depending on the value of one particular field. e.g. Between 1 and 5 adjacent records in the table have the same invoice# and are entries on an invoice that the report generates. I assume this can be done, but I have no idea how (with or without using VBA code)?
Click to expand...


Check out the Sorting and Grouping feature (View menu).
From your description of what you want, it sounds like all
you need is to group on the invoice number field (possibly
with header and footer sections).
 
----- Marshall Barton wrote: ----

ctdak wrote
I need to create a report that has anywhere from 1 to 5 records in the detail section at a time, the number varying depending on the value of one particular field. e.g. Between 1 and 5 adjacent records in the table have the same invoice# and are entries on an invoice that the report generates. I assume this can be done, but I have no idea how (with or without using VBA code)
Click to expand...


Check out the Sorting and Grouping feature (View menu)
From your description of what you want, it sounds like al
you need is to group on the invoice number field (possibl
with header and footer sections)
--
Mars
MVP [MS Access

Marsh

Your'e right of course, and I knew that! I've done this before. Guess I had a mental lapse
Thanks for answering

ctda
 
Back
Top