Microsoft Reports - Labels

[bmorganh]

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?"

 

[Douglas J. Steele]

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.

 

[_Bigred]

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?"

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/