i have designed a database for neighbiourhood watch members. they will also
be owrking on oue extended public works program.
problem
they work a certain number of days per week. there rate of pay is 50.00 per
day. we also pay there bank fees. which 3.50
the calculation should be field1(num of days worked) x field2(rate per day)
+ bankfees= amount due. in excel i can do this calculation with my eyes
closed. plse assist
If you're asking about an Access calculation, an solution would be two
write a query in which one of the columns specifies the following in the
field row:
AmountDue: [field1]*50 + 3.50
If you're asking about an InfoPath calculation, you need to create a
text box, and specify the default value for it. Use the formula wizard -
it will help you generate the formula you are looking for.
Good luck,
Alex @ Microsoft
-----Original Message-----
From: mogamat keraan [mailto:mogamat keraan@discussions.microsoft.com]
Posted At: Wednesday, May 04, 2005 2:49 AM
Posted To: microsoft.public.infopath
Conversation: calculation in access
Subject: calculation in access
i have designed a database for neighbiourhood watch members. they will
also
be owrking on oue extended public works program.
problem
they work a certain number of days per week. there rate of pay is 50.00
per
day. we also pay there bank fees. which 3.50
the calculation should be field1(num of days worked) x field2(rate per
day)
+ bankfees= amount due. in excel i can do this calculation with my eyes
closed. plse assist