Complicated Query from two tables

[Latoya]

I have a Rates Table which consist of some rates(half weekly rates, weekly rates & monthly rates)...the other table is an attendance table which consist of names, date, absent or present(yes/no) field.

Now the query or report I would like to run is when a child attend 3 or less days in a week...the half weekly rate must apply, when they attend more than 3 days the weekly rate will apply...also there are a few monthly payments.

I'm having a hard time coming up with the right results.

Any help is greatly appreciated.

Thanks in advance.

 

[reclusivemonkey]

You will need more than one query for this I suspect. I would start by creating a query that calculated the number of days attendence per week per child. You would then link this to the rates table with an IIF condition attached to the days to pick up the correct rate. Without knowing any more about what you require I can't really offer any more advice. Make a start with that and let us know how you go on.