Report Sorting

R

Radar

I have report that is sorted by Store Number with various line items.
? How to I sort or print out all the stores with the same detail
records or same line items?
Thanks
Radar
 
G

Gina Whipp

Radar,

Duane asked for more details and you have chosen to repeat the question only
a little more obsure then the first time. I THINK you want to use report
Sorting and Grouping but without more specific details that's about as
specific as I can get. And let's not repost the same question AGAIN here or
in another newsgroup, help us out with more details.

Gina Whipp
 
J

John Vinson

I have report that is sorted by Store Number with various line items.
? How to I sort or print out all the stores with the same detail
records or same line items?
Thanks
Radar
Click to expand...

How are you using the term "sort"? In database lingo, it means "take a
set of records and put it into a specific sequential order". It sounds
like you're making the common misusage meaning filter, or select.

As Gina requests... please clarify. Do remember that we cannot see
your database, do not know anything about its structure, and are not
familiar with your business.

John W. Vinson[MVP]
 
R

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
 
G

Gina Whipp

Radar,

If I am understanding correctly you want a Pick Ticket but by item, not by
store but showing the store, assuming this is correct...

In your reports design view do you have any 'Grouping and Sorting' now?
Because if you eliminate the Headers and just put all the information in the
'Detail' section you should get all the items and then the store name.

Quantity - Item - Store Name
4 pads - Halloween Project Sheets - Store 171
4 pads - XMas Trees - Store ???

and so on. Is this what you want or did I misunderstand?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
 
R

Radar

Sorry for not being clear.
I have a line set up for my pickers to fill orders. What I need to do
is Print out Pick tickets of all the stores that receceived the same
items. For example. Out of 818 stores 50 of these stores will receive
the same 5 Items. 118 store will recieve 9 of the same items. an so
on. I need to sort my pick sheet so my pickers can flag only the
items they need to grab.

My question is how do I group the stores that receive the same items.
each pick sheet will have its on store number with line items listed.

I hope this helps
Thank for being paient

Radar
 
G

Gina Whipp

Okay then is it

4 pads of XMas Trees
Store 171
Store 222
Store 245

4 pads Halloween Project Sheets
Store 171
Store 245

To do that, I would

1. Go to 'Design View' of the report
2. Click on the 'Grouping and Sorting' button
3. In the window that opened up select under 'Field/Expressions' the item
and in the 'Group By' section at the bottom select 'Yes' for Header and
close out of the 'Group and Sorting' window.
4. On the report (while in design view), move the 'Item Description' under
the Group Header by that name and place the Store names in the detail
section.

Hopefully, I explained that correctly and understood correctly, if not post
back.
 
Top