constant numbers on report

J

J Coon

I need to create a report with 24 numbered lines and fill
in the data from a table. The table has the numbers in it
but not every item has 24 thing. it may have numer 1, 2, 3
16 and 20. How do I ensure that the numbers 1-24 are
always on the report and the records lin up to tha
appropriate numbers?
 
J

Jeff Boyce

One way I've approached a similar problem is to generate the list of 24 line
numbers, then use a "directional" join to include all those numbers and any
related values.

Does your table "know" which line numbers it values belong to?

Good luck

Jeff Boyce
<Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Autonumber field in Excel that behaves the same as Access 0
Paragraph numbering in Word 1
Finding the proper style field and the numbered paragraph value within the style 0
How to change font & size of (all) citation numbers? 7
Possible to Combine reports to's to a single box? 0
Finding the right style field in VBA 0
Page numbering with Merged Document and IF statements 1

Top