Add, Subtract, multiply a Field

[TBC]

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

 

[Ranman256]

you do the same thing in a query, (and give it a name)

ProjAmt: ([field1]/[field2]*[field 3]+[field 4]+[field 5])