Search results for query: *

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...

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...

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...

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...

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...

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

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()...

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

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...

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")...

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...