Recent content by sydeburnz

uncle gizmo, you are almost with me. what I was looking for are the items that have never sold in any of the stores. Basically, if they have an item that was included in their original inventory when the store was opened and it still has not sold to date. i did make some headway yesterday...

On the category thing, I cannot unfortunately. As a last resort, I can do a edit/replace all in Excel when I am done with the initial project

actually, the data that I am looking for is what has never sold. the first query gets me that data per store. i got the data by showing only items that have no data recorded in the 'lastBuyDate' field. If something had sold, no matter how long ago, it would have a date. This is my primitive...

First time poster, so I hope someone shows me the light and makes your forums shine! :) I have a POS system that was designed in house which uses Access. I am trying to create some queries outside of the system to retrieve some data that has been being stored. I am basically wanting to know...