Sorting Records

[Radar]

? How do you , sort or print records. whith the same detail or line
items.
Example store 1, 5, 6 have the same records or line items

Thanks
Radar

 

[Larry Linson]

? How do you , sort or print records. whith the same
detail or line items.
Example store 1, 5, 6 have the same records or
line items

Could you clarify what problem you are having? If you sort first on StoreID
and then on the other Fields of interest, either in a Query, or Group in a
Report by StoreID, it should work.

If you are expecting some particular order in a Table, however, you should
be aware that, by definition, relational database tables are _unordered_ so
you need to put them in some order with the Query you use to retrieve them,
or the Sorting and Grouping properties of the Report where you use them.

Larry Linson
Microsoft Access MVP

 

[Radar]

I have about 818 stores , that I have to ship supplies to.
Store# 171
1) 4 pads - Halloween project shts
2) 4 pads - Xmas trees - project shts
3) 4 pads - Halloween Cakes - projects shts

Some of these stores could receive 8 items or 12 items and so on
I need to print out Pick tickets in batches according to number
of items
That each store needs. ( all the store that receive 3 item or 6 items
etc.)

At this point I can only sort them by Store# order , then Supply
order.
Thanks for being patient
Radar

 

[Larry Linson]

I believe your question has been answered in another newsgroup, where you
also actually described the content of the pick tickets -- grouped by item
number, with store on the detail line, not as implied here.

In the future, if you feel compelled to ask the same question in multiple
newsgroups please do it by crossposting... adding multiple newsgroups to the
newsgroups line of the header, rather than multiposting. It will save time
and energy for people who volunteer answers to questions here, because they
will be able to see the whole list of answers in each newsgroup. For other
good suggestions on effective use of newsgroups, see
http://www.mvps.org/access/netiquette.htm.

Larry Linson
Microsoft Access MVP