I'm a newbie and am trying to build an inventory database. I want the database to retain each period's physical count and the pricing at the time of the physical count. Stated differently, I want to be able to track historical physical inventory periods (both quantity of goods and their pricing). I keep running into problems creating reports for staff to perform the physical count of the items at various facilities and locations within the facilities and then closely replicating the order of these physical count reports in a form so the user may enter these quantities accurately. I'm now at the point of wondering if it's my inexperience creating forms and reports or whether the overall structure of the database is flawed. Any input would be welcome (db attached). Thank you in advance!