Search results

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

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

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