Inventory help

[fireup3]

I'm a relatively new Access use, so this may be a very simple problem. I'm setting up a simple table for inventory control at my wife's store. In a query, I'm trying to select records for items that have recently sold. I expect records that are exact duplicates of each other to be extracted and visible in the query, but anything that is a duplicate is not getting returned in the query. Both UniqueValues and UniqueRecords are set to No, and I even tried to add an Autonumber counter to the table to see if the query would then see the duplicates as unique records, but still no duplicate records.

Anyone have a suggestion?

 

[ColinEssex]

Do you need to show duplicates?

If you have all items listed with the stock level number and you enter how many you sold that day then the stock level shows the new value. Presumably when the stock level for an item reaches a certain number if flags up that you need to re-order it. etc etc

or am I on the wrong track here

Col

 

[fireup3]

Colin, thanks for the help, but I'm not using stock level. At the very basic level, I want the query to show all records, even when they are exact duplicates, and I'm not finding the key to make that happen.

 

[Gootz11]

I'm not sure of what you are really trying to do but it sounds like you are "grouping" the items in your query, if this is the case the solution is just to click your "Totals" icon on your tool bar. However, a simple way to leave your calculations in the query (in case you are trying to sum another column) is to put two colums in the query for the record that you are having problems with
Example
lets say you sold 3 different pairs of shoes of the same style for $10 each: your query would look like this

field: Item Item Price
table: Store Items Store Items Store Items
total: Group by Count Sum
sort:
show:
criteria:
or:

When you run the query it will look like this
Item CountofItem SumofPrice
111 3 30

If you throw another field on there that is unique to every sale. example a "date" or even better an "invoice number" then your query would look like this

Item CountofItem SumofPrice Date Invoice#
111 1 10 1/01/03 100
111 1 10 1/01/03 101
111 1 10 1/01/03 102

Then eventually you can put a date parameter on your criteria (>=start date and <=end date) so you will only see the record for a certain time period
hope that helps