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

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

    YTD Running Total by Month

    I need to calculate a ytd running total of sales by month by customer. That is, for Jan 07, I need a total of sales for 2/1/06 through 1/31/07, for Feb 07, a total of sales for 3/1/2006 through 2/28/07, etc. Here is the layout Apr 2007 May 2007 June 2007 Customer 1...
  2. mparshley

    use running sum to get consumables sold by equipment installation

    I don't know where to start with this. My goal is to report the consumables sales dollars per equipment installed at a customer. Both are sold by us. Table: customer name, sale date, part number, sale quantity, sales dollar. The part number is used identify equipment vs. consumables. The...
  3. mparshley

    Using Running total in Crosstab formula

    Is this possible? We want to use a crosstab table to report the average purchase of consumables per customer installation. I can use the running total to accumulate the number of installations on site. I would like to divide the total consumable purchase by the running total of installations...
  4. mparshley

    logging onto Access db with user level security

    I need some newbie level instructions for signing on to an Access database that is secured at the user level in a shared workgroup .mdw file. The .mdb and .mdw files reside on the same server. What is the code to do this and where do I enter it? Thank you.

Part and Inventory Search

Back
Top