Report help

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

Guest

I have a deliveries database that i created. All items delivered go into the
subform at the bottom. When i print my report it prints the last item in the
subform as the firs. This doesn't work because the first item is usually a
heading and so now things don't look right. what could be some possible
reasons for this?

thank-you
 
The first item is a heading? That does not sound like a normalized design.

In any case, you would need to pick a field and sort by it. If you want a
record that must always print first, make sure the field you sort on is
first in order numerically or alphabetically. If there is no field that
will do this, then you would need to add a field to your table that include
the line number or sort order or something similar.

Again, this does not sound like normal design. You should not have to enter
a record for each order to include as a heading.
 
Back
Top