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!

Register Log in
  • 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. AccessExcelHell

    Subtotals in Query

    Hi, Currently, I have this query in access(where I am using totals, group by, etc), which gives me the totals per LOC ID. But then I need to get totals by Area Name, so I copy into Excel to use the Excel Subtotals function. Is there a way to do the same in access? Region: can have many Area...
  2. AccessExcelHell

    Query(4 tables) - Prim key record (not in1 table) - No Data!! HELP

    Hello, I have a query that gets and computes info from 4 tables. Which get updated each month. The problem that I am having is that, if in any 1 of the tables, the Primary key(location id) does not have a record (for that month), then the query does not give any data for that location. I know...
  3. AccessExcelHell

    Set Query Parameters in a Macro

    Hi, I have a query with 1 field where the criteria value changes. I want to create a macro that runs this query for each possible value of the 1 field. I tried to use the SetValue function prior to running the query but that didn't work. Any ideas? Thanks in Advance.
  4. AccessExcelHell

    Query, sum, avg, group by month for 12 months

    Hello, I need to create a query that will look at data in a table and perform count, sum and avg functions (which i know how to setup) butthen i need this dat per month. I can only get access to do 1 date range. I need help so that i can get the results for each month in the year. Ex. Table...

Part and Inventory Search

Back
Top