Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / May 2005

Tip: Looking for answers? Try searching our database.

calculation in access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mogamat keraan - 04 May 2005 10:49 GMT
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

Alex [MSFT] - 05 May 2005 05:16 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.