Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: scottcraft
  • Content: Threads
  • Order by date
  1. scottcraft

    Inventory Control for multiple locations

    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...
  2. scottcraft

    Updating two tables using 1 form

    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...
  3. scottcraft

    Multiplication Issue

    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...
  4. scottcraft

    reasking an Access Question

    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...
  5. scottcraft

    yyyymm

    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...

Part and Inventory Search

Back
Top