|
| 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
September 8th, 2004, 08:05 PM
|
|||
|
|||
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
September 8th, 2004, 08:39 PM
|
|||
|
|||
|
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 |
Linear Mode
