Add, Subtract, multiply a Field

[TJVFree]

Hello,

I'm trying the to calculate the projected amount. I'm needing help putting this formula together using 2013 MS Access

for starters I need to be able to
Calculate the number of days to date in a month
Calculate the number of days left in the month.

I tried putting together some calculations below if that helps explain what I’m trying to do

FEES_COLLECTED
$11433.44
$476.39
$3,334.75
$14,768.19

in excel the formula should look like the following
$11433.44
=E33/24
=E282*7
=E33+E283

Projected amount: ([$11433.44]/ ([$476.39]*[ $3,334.75] +[$14,768.19]
Projected Amount: ([$11433.44]]/[E33/24]
Projected Amount: ([field1]/[feild2]*[field 3],[field 4]+[field 5]

FEES_COLLECTED
$11433.44
$476.39
$3,334.75
$14,768.19


$11433.44
$476.39
$3,334.75
$14,768.19


TCB

 

[Andrzejek]

[green]'number of days to date in a month[/green]
MsgBox Day(Date)
[green]
'number of days left in the month.[/green]
MsgBox DateDiff("d", Date, DateSerial(Year(Date), Month(Date) + 1, 0))

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

What do E33 and E232 refer to as field values? Excel is of little help. All your formulas are difficult to put into a meaningful context.

Please explain.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Andrzejek]

" in excel the formula should look like the following"[pre]
$ 11433.44 Some amount to start with?
=E33/24 11433.44 / 24 = 476.39 Amount divided by 24 ?
=E282*7 476.39 * 7 = 3334.75 Result multiplied by 7 ?
=E33+E283 14,768.19 Have no idea what this is...[/pre]

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.