cclark9589
Registered User.
- Local time
- Today, 15:03
- Joined
- Sep 22, 2008
- Messages
- 79
Please bear with me here; I'm a novice when it comes to Access so any answers will need to be spelled out very sssssssllllllllllloooooooowwwwwwwwllllllllllyyyyyyyy.
I've put together a database fashioned after a template I located on the Microsoft templates - Time and Billing database. I'm having a bit of trouble getting all totals displaying on the subforms and will try to describe it.
The main form is for the clients with the subform displaying all the payroll jobs associated with that particular client. The subform lists the payroll job name, hours, fees, expenses plus a calculated field for the total billable amount. The hours and expenses come from the time cards which have two subforms; one for hours and one for the expenses.
What's happening is that if I enter hours for a payroll job and there are no associated expenses, the total billable amount on the clients subform doesn't display. It shows the hours and the fees for those hours but the total billable amount doesn't show. If I go back into the time card and then go to the expense tab and put zero expenses in, the total billable amount shows on the client form.
Not all jobs will have expenses and I find it at least inconvenient to have to enter something to get the total to display.
I've tried setting the default value to zero in the tables/form properties but nothing seems to work. I've also tried putting in an IIF statement to no avail. Any ideas would be greatly appreciated but please remember; I'm old and slow!
Thanks in advance.
cclark9589
I've put together a database fashioned after a template I located on the Microsoft templates - Time and Billing database. I'm having a bit of trouble getting all totals displaying on the subforms and will try to describe it.
The main form is for the clients with the subform displaying all the payroll jobs associated with that particular client. The subform lists the payroll job name, hours, fees, expenses plus a calculated field for the total billable amount. The hours and expenses come from the time cards which have two subforms; one for hours and one for the expenses.
What's happening is that if I enter hours for a payroll job and there are no associated expenses, the total billable amount on the clients subform doesn't display. It shows the hours and the fees for those hours but the total billable amount doesn't show. If I go back into the time card and then go to the expense tab and put zero expenses in, the total billable amount shows on the client form.
Not all jobs will have expenses and I find it at least inconvenient to have to enter something to get the total to display.
I've tried setting the default value to zero in the tables/form properties but nothing seems to work. I've also tried putting in an IIF statement to no avail. Any ideas would be greatly appreciated but please remember; I'm old and slow!
Thanks in advance.
cclark9589
Last edited: