This is a big one. I am preparing an inventory for 8 seperate locations. The want to track beginning inventory, actual count, shortages, sold and new new inventory. Updates will be made a minimum of weekly. Want to be able to track sales for all locations. This is a cologn and perfume kiask...
I am using two tables in a consolidated form. I would like to be able when I update the form that both tables be updated. Meaning that the new primary key information placed in the 1st table be automatically inserted to the 2nd table. The items in both tables are CUSTOMER and PARTNUMBER...
I am new to the Access world, but loving it. I have been tasked to create a simple mathamatical formula, however I just don't have the knowledge (yet). I have two columns named OnHand (inventory On Hand) and PricePer (cost per item). I want to create a query with a third column called...
I am new at this so I appologize for not giving enough information. I am in the US Army and developing a reporting system that shows when soldiers are due periodic physicals (required every 5 years) and annual Physical Fitness Tests. The date for each LAST_PHYS and APRT are in a text format...
I am wanting to use a table with the date entry of yyyymm and be able to find out when the date is 13 months old. example 200001 and 200101 it is fine, but at 200102 it becomes late. there are processes which must be updated yearly, I need to find out without changing the formula, how to do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.