expressions

S

Sophia

I need the solution for 3 Simple expressions. Sum and subtraction.For example:
subtotal1 + subtotal 2 = TOTAL
subtotal 1 - subtotal 2 = TOTAL
date1+7 days= DATE 2
 
P

pietlinden

I need the solution for 3 Simple expressions. Sum and subtraction.For example:
subtotal1 + subtotal 2 = TOTAL
subtotal 1 - subtotal 2 = TOTAL
date1+7 days= DATE 2
Click to expand...

Is this in a form (an unbound textbox) or in a query? If subtotal1
and subtotal2 are controls on your form, you can just create an
unbound textbox and set the controlsource to =Subtotal1 + Subtotal2
for the date problem, you can use DateAdd("d", me!txtDate1, 7)

but we really need more information to be sure. So, is this in a
query, a form, or a report?
 
Top