M
mark
I am building a management database system for my company. I am using ms
access 2007. For the problem I am receiving is calculating fields for my
billing database. The following fields are part of the structure.
Hours
Hourly Rate
Days
Daily Rate
Sub Total
What I want to do is calculate the fields to give a total in the field Sub
Total.
So
(IF [Hours] = true) then times the [Hours] Field and [Hourly Rate] Field to
Give the Sub Total,
this will also apply to the [Days] field.
Do I have to create a query to run this command or can I enter in the string
via the properties fields.
Please help as I have not used access much before and this is battling me
and it is pretty important that I get this done asap.
Many thanks
Mark Bray
access 2007. For the problem I am receiving is calculating fields for my
billing database. The following fields are part of the structure.
Hours
Hourly Rate
Days
Daily Rate
Sub Total
What I want to do is calculate the fields to give a total in the field Sub
Total.
So
(IF [Hours] = true) then times the [Hours] Field and [Hourly Rate] Field to
Give the Sub Total,
this will also apply to the [Days] field.
Do I have to create a query to run this command or can I enter in the string
via the properties fields.
Please help as I have not used access much before and this is battling me
and it is pretty important that I get this done asap.
Many thanks
Mark Bray