Need sorting help please

[crystalda726]

Hello, I am new to this site and was hoping somebody could help me out. I have a table for my company inventory and I am trying to make a report from that table. Due to the fact that the it is inventory, it has to be sorted exactly how I entered it in the table. There is no way I could sort it in a sub catagory. For some reason, everytime I run the report it is not in the same order that it is in the table. I can't even figure out how it is sorted as there is no order to it. Does anyone know how I can get it to run with the information exactly as it appears in the table? Any input would be greatly appreciated.

 

[KenHigg]

Is there any fld in the table that you can sort it on? If so, you need to right click in report/design view and sort it there.

kh

 

[crystalda726]

No

The way I have it set up is Item#, Quantity In stock, Quantity Sold, Quantity Ordered, Revised Stock Quantity, Date, and Purchase Order Number.

The purchase orders come from different companies, so I can't sort by that and if I sort by any of the quantities, I don't come up with the right Revised Stock Quantity. I can sort by date, but sometimes items are sold and received on the same date and it doesn't come out right. I have tried this all different ways, and can't figure anything out.

 

[Mile-O]

It sounds like you have no primary key and are binding the report directly to the table.

 

[Ukraine82]

Try making a report from a query...and from there you can select a field that you to be in ascending/descending order.

hth,
Michael