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 Chriss Miller 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. mgerard802

    Grouping by a formula

    I have a table with client transactions which I am summing the total for a range of dates for the current year and prior year. I then want to compare the totals for each year. I then want to group all the clients where the total amount has increased. Then group the clients where the total has...
  2. 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...
  3. 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...
  4. mgerard802

    Date parameter & comparison

    Thanks, here is what I have: SELECT sum(Timespend) as CY, (select sum(timespend) from tblmain where Period between DateAdd ("y",-1,[StartDate]) and DateAdd("y",-1,[EndDate])) as PY FROM tblProducers INNER JOIN tblMain ON tblProducers.ProducerID = tblMain.ProducerID where...
  5. 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...
  6. 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
  7. 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()...
  8. 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
  9. mgerard802

    Adding anc copying to a new worksheet based on data

    Nikki, Once again, thank you. One more question. When I try to run the macro with other files (personal.xls or when I have the original open and run it in another open workbook), the macro stops on the Set l_wksNameTable = ThisWorkbook.Sheets("NameTable") line saying the subscript...
  10. mgerard802

    Adding anc copying to a new worksheet based on data

    Nikki, Thank you very much for the code. I tried running it, and I am getting an error. I named the worksheet NameTable to get past the 1st error, now I am getting "Method 'Range' of object '_Worksheet' failed." on the l_vArray = l_wksNameTable.Range("rngNameTable")...
  11. 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