constant numbers on report

  • Thread starter Thread starter J Coon
  • Start date Start date
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?
 
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>
 
Back
Top