Recent content by Cansley

I did consider that. Seemed like the "long way" and I had hoped for more efficent solution but there appears to be none. Many thanks for the reply.

Hi. I have tired searching to no avail, so appologies if this is covered somewhere already... I am trying to calculate the carried balance on a equity incentive award that earns a variable rate of return each year and can be paid at the end of the 4th year as a lump sum in full or in part (if...

Hi I am building a forecasting database that will have known amounts entered for various projects. If a project has no known future amount (lets say for next March), I want my query to calculate a projected number by taking the most recent equivilent month (for this last March,which may be a...

Thanks again very helpful thanks so much

THANKS works great!:)

Please help! I need to examine a table and find first number >1 in "location" field, then replace "location"= zero until next "location" >1 then replace following zero "location"s with the new number & so one. I know I have a problem with the second loop, but can't figure it out. example- if...

First of all, thanks for replying. I have been trying to do as you suggest and have hit a snag. this what I have so far Sub copyloctions() 'Declare and instantiate a recordset Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset Dim strSQL As String Dim strSQL1...

Hi I have to clean up an imported table that only has a cost center (1st field) on the first record (monday) of a weeks worth of data. The other four days have null values until the next monday come around. I need a way to fill in the cc number on the other four days, then reset it to the new...