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: *

  1. SirWaldizmo

    Creating new worksheets from a single list

    Hi, I have a list of states, cities within the state, and counts of patrons in each city in one long list. I'd like to know if theres a way to create a new worksheet for each state? thanks
  2. SirWaldizmo

    Calculating a total in a form from 2 tables

    Hi... I have 5 tables. tblProducts tblIn tblOut tblOrders tblOrdersDetails I'm creating a form that will allow entries into tblIn. In this form i would like a textbox to display current inventory via calculation. Logic of calculation as follows.. CurrentInventory = sum(tblIn.quantity) -...
  3. SirWaldizmo

    Help finding IDs with FIVE CONSECUTIVE YEARS of Service

    Hello, I have a table of two columns one is ID and the second is Year_Of_Service. IDs are duplicated in this table where there are more than one year of service. Does anyone know of a logic in sql that can find all the IDs that have at least 5 consecutive years of Service. Any suggestions will...

Part and Inventory Search

Back
Top