Using Access to Compare Tables

[britsgal]

Ok, I am hoping that someone can help me with what I need to do. I have extremely limited Access knowledge so I really, really need some help. I work in retail and am trying to compare items that are on auto-replenishment for a particular location to items that the location should have in their retail assortment to make sure that all of their items are on auto-replenishment. I need to also perform the comparison backwards to find out if any items are on auto-replenishment that should not be because they are not carried in the location's retail assortment.



I have attached a file below that shows the files I am working with. The first tab "items on replen" show the item # (in text and general formats) along with the location number, the min and the max. The 2nd tab "POG's by Center" show the retail planograms assigned to each center. The location# is at the top of the file and the planogram numbers fall below each location #. The 3rd tab shows the items on each planogram. The first thing I need to do is convert the planogram # into items on each planogram in each center. This is what I would need to use to compare to the items on replen.

I'm not sure how to do any of this. We tried doing it in Excel but the data was so massive, it wouldn't calculate. The actual "items on replen" file has approximately 995,000 rows of data. If anyone could steer me on how to conquer this, it would be greatly appreciated.

Thank you!!!! Laura

[June7]

These are your actual tables in the Access database? This structure makes no sense to me.

'POG's by center' is not a normalized structure and that's probably a big source of your difficulties.

'Items on replen' does not appear to have any relationship to the other tables.

None of the numbers used can be reconciled. There is no '103' Loc ID.