Coding for reports

[Dos Equis]

Hi all,

I need to calculate four totals for a report. I would do this in a
query except that I have used a look up field as one of the numbers I
need now and Access refuses to use the value for an expression.

1) I need to determine the rate at which I pay. If an emplyee has
worked for me more than 30 days, they are paid $.05 per piece, if less
than 30 days then $.04. I assume the code needs to look something
like:

Rate: If [tbl_Carrier]![Hired]=Date()-30, 0.05, other 0.04

2) I then take a calculated sum in qry_Area and multiply by the
outcome:

Home Pay: [qry_AreasAndHomes]![Homes]*(ValueAbove)

3) I also calculate the number of subscribers in the area and multiply
by $.20:

Sub Pay: [qry_CurrentSubscriberCountByCarrier]![Subs]*0.20

4) Then I need to add the totals together

Carrier Pay: ([qry_AreasAndHomes]![Homes]*(ValueAbove))+
([qry_CurrentSubscriberCountByCarrier]![Subs]*0.20)

I would combine all steps except I need to show details for
accounting.

My questions are:

1) Is this easy to do and I'm just missing the answer?
2) If so, would someone please point me in the right direction?
3) Do I need to code for any of this and what is it called so I can
find it in the 3 books I have?

Thanks for any help you can provide.

Byron