If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I Calulate Cost based on another field?
I want to calculate the shop fee if there is data in the labor hours, how do
I do this? |
#2
|
|||
|
|||
How do I Calulate Cost based on another field?
"Expression" wrote:
I want to calculate the shop fee if there is data in the labor hours, how do I do this? Guessing here - since I have no idea how your tables are structured or how the shop hours can be converted to dollars - you can create a Query based on the table. In a vacant Field cell type ShopFee: [Labor Hours] * 12.50 if the fee is $12.50 per hour. If the fee varies depending on the type of job you'll need a fee table, and a more complex expression. -- John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort the record based on a field | Irshad Alam | Setting Up & Running Reports | 1 | September 5th, 2005 11:53 PM |
Default Value of field based on another field of same record | Naresh Kumar Saini | New Users | 5 | May 24th, 2005 03:11 AM |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |
Calculated Field Problem: Picking a date based on value in another field | Dkline | Database Design | 3 | June 23rd, 2004 04:05 PM |
Create table with field names based on the value of a field in another table. | [email protected] | Database Design | 5 | May 24th, 2004 02:32 PM |