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 derfloh 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: mgerard802
  • Content: Threads
  • Order by date
  1. mgerard802

    Grouping by a formula

    I have the following formula: if (sum ({@BV-Current}, {tblClients.ClientName})= 0) then "New" else if sum ({@BV-Prior}, {tblClients.ClientName})= 0 then "Lost" else if sum ({@BV-Current}, {tblClients.ClientName}) > sum ({@BV-Prior}, {tblClients.ClientName}) then...
  2. mgerard802

    Date Comparison

    I have a table with transactions over a range of time. I want the user to enter a date range, then have the report sum the data by employee, have 1 column for the date range entered, and 1 column for the date range minus 1 year. For example Employee Amount Date 1 10...
  3. mgerard802

    Date parameter & comparison

    I have a query where the user enters a begin date & end date for criteria (1/1/03 - 3/31/03). Another column sums data and return the sum for the date range entered. How do I get another column summing the data for the same date range (ie 1/1/02-3/31/02) for the prior year? Basically a...
  4. mgerard802

    Suppress 0 amount rows in a Pivot Table

    I have a pivot table with number of 0 amount rows. Is there a way I can suppress those rows to make the report easier to read? Thanks
  5. mgerard802

    Copy multiple ranges

    I am trying to coy multiple named ranges, each on a different worksheet to another worksheet. Here is what I have so far, which I am running into problems with. I am getting an error when I try to copy. Any help would be appreciated. Thanks. Private Sub Workbook_Activate()...
  6. mgerard802

    Read-Only Excel

    We have a number of old Excel files which we would like to have as read only. I know we can change the properties and add passwords to edit the file, but those functions can be reversed fairly easily. What else can we do it have them read only? Thanks
  7. mgerard802

    Adding anc copying to a new worksheet based on data

    I want to to add worksheets and copy certain data to the new worksheet based on values in a column. For example: Name Amount Mike 1 John 1 Sally 2 John 2 John 2 Mike 5 So I would want to add a worksheet for each name, and copy the appropriate data for that name. A new worksheet...

Part and Inventory Search

Back
Top