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
|
|||
|
|||
Modifications to Time and Billing database template
I removed the ExpenseAmount fields from all tables, forms, subforms and
reports. I've replaced it with two fields: ExpenseQty and ExpenseUnitCost to be calculated with an expression in the forms and sub forms. Wherever there are billing (invoicing) totals (client forms, client subforms and Invoice Report) I get errors due to a query that is still looking for the ExpenseAmount fiield. How can I fix it? |
#2
|
|||
|
|||
Change the query to calculate the value based on the two fields.
-- --Roger Carlson www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "CCallies" wrote in message ... I removed the ExpenseAmount fields from all tables, forms, subforms and reports. I've replaced it with two fields: ExpenseQty and ExpenseUnitCost to be calculated with an expression in the forms and sub forms. Wherever there are billing (invoicing) totals (client forms, client subforms and Invoice Report) I get errors due to a query that is still looking for the ExpenseAmount fiield. How can I fix it? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time and Billing Database from MS Office Online | Stumped | New Users | 1 | July 20th, 2004 12:13 AM |