Microsoft Reports - Labels

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

Guest

I use Access to make labels for file folders. The text for the labels is the
field in a data table called "File Name". My question is: "Is there way to
have the labels printed chronologically in the order they were entered rather
than alphabetically?"
 
Assuming you've got some way of telling the order in which they were entered
(like a Create Date/Time), order by that field.

If you don't have such a field, then no, there's no way to guarantee the
order in which they'll be printed.
 
bmorganh said:
I use Access to make labels for file folders. The text for the labels is
the
field in a data table called "File Name". My question is: "Is there way
to
have the labels printed chronologically in the order they were entered
rather
than alphabetically?"
Click to expand...


I have a report that I need to have print a roster in the order in which
they were entered. I simply created a rankFIELD in the source table, gave
each record a numerical rank and then setup a query (sort ascending or
descending depending on your need) kick to report and it does the trick
nicely.

Hope this helps,
_Bigred






I'm protected by SpamBrave
http://www.spambrave.com/
 
Back
Top