hockey8837
Registered User.
- Local time
- Today, 07:37
- Joined
- Sep 16, 2009
- Messages
- 106
Hi,
I'm working with the Accounting template DB, and am currently formatting it to my needs. I'm trying to work with a form to look at a transaction's details. This my second attempt at this DB, the first stopped totaling for some of the transactions and I couldn't debug, so I started over.
I'm having problems with getting it setup properly and getting the correct calculations to perform. Here's my situation:
I currently have a Transactions table and an Accounts table (among others...). In my Transactions Details form, the user selects which account the transaction is for from a combo box pulling the data from Accounts, then fills out the remaining information in the form (dates, category, purchase order #-if available, etc).
So, here's my issue: Each transaction falls into one of 3 types; Materials, Hours, or Contractor Maintenance Supervision.
Issue 1: I've made 3 separate areas on the same form for each of these, partially because I can't figure out how to make only the associated section appear if a user selects that particular value from a combo box (which would be ideal). I don't know how best to do this.
Issue 2: I've also got a [Billed Amount] box (this should be a total of the form), which, if my IIf Null statement would work right, would fill with either the [Materials Cost], the Hours:[Rate Cost], or the Contractor Maintenance Supervision 12%:0.12*[Contract Cost]. Here's my statement which I've put into the Control Source of the combo box [Billed Amount]
Billed Amount: IIf(IsNull([Rate Cost]),IIf(IsNull([DCH 12 Percent]),[Materials Cost],[DCH 12 Percent]),IIf(IsNull([Materials Cost]),[Rate Cost],[Materials Cost]))
This IIf(IsNull) statement worked in my previous DB when I had it calculate in a query controlling the form, but I was going to try to put it right into the control source for the text box this time because of my issues with the last attempt at this DB. I've attached a copy of the DB, and would appreciate any help! Thanks!
I'm working with the Accounting template DB, and am currently formatting it to my needs. I'm trying to work with a form to look at a transaction's details. This my second attempt at this DB, the first stopped totaling for some of the transactions and I couldn't debug, so I started over.
I'm having problems with getting it setup properly and getting the correct calculations to perform. Here's my situation:
I currently have a Transactions table and an Accounts table (among others...). In my Transactions Details form, the user selects which account the transaction is for from a combo box pulling the data from Accounts, then fills out the remaining information in the form (dates, category, purchase order #-if available, etc).
So, here's my issue: Each transaction falls into one of 3 types; Materials, Hours, or Contractor Maintenance Supervision.
Issue 1: I've made 3 separate areas on the same form for each of these, partially because I can't figure out how to make only the associated section appear if a user selects that particular value from a combo box (which would be ideal). I don't know how best to do this.
Issue 2: I've also got a [Billed Amount] box (this should be a total of the form), which, if my IIf Null statement would work right, would fill with either the [Materials Cost], the Hours:[Rate Cost], or the Contractor Maintenance Supervision 12%:0.12*[Contract Cost]. Here's my statement which I've put into the Control Source of the combo box [Billed Amount]
Billed Amount: IIf(IsNull([Rate Cost]),IIf(IsNull([DCH 12 Percent]),[Materials Cost],[DCH 12 Percent]),IIf(IsNull([Materials Cost]),[Rate Cost],[Materials Cost]))
This IIf(IsNull) statement worked in my previous DB when I had it calculate in a query controlling the form, but I was going to try to put it right into the control source for the text box this time because of my issues with the last attempt at this DB. I've attached a copy of the DB, and would appreciate any help! Thanks!
Last edited:
