I am fairly new to Access and came in a little over confident based on my Excel abilities which aren't as easy to translate as I had imagined. In Excel I would use VBA but I'm not familiar with it here and there might be a better option. I would really appreciate it if someone could help guide me thru this.
I have a table named 'tbl_2nd Floor Open Replen Picks' that is my source data. It looks like this:
ITEM_NO WHSE_CODE ITEM_UM MIN_OH SumOfLOCT_ONHAND ORDQTY PICK_LOC Level STD_CONT_QTY # OF CONT Run Time 2168-4993 S LBS 39 5.08 2220 On Site Store B 553 4 1/9/2018 5:19:18 PM B582C92 F LBS 7176 251 4784 Y213 C&D 55 9 1/9/2018 5:19:18 PM
I need to make query that will populate a different table ' tbl_2nd Floor Cont Picks' with all of the items in the source table but I need each item listed the number of times in # OF CONT. Based on the example above the line 2168-4993 would be listed 4 times and B582C92 would be listed 9 times. I can do this in Excel with VBA very easily but I am struggling to apply that to Access.
Thank you