Message for Jon K (1 Viewer)

[Geoff Codd]

Thanks for your help the other day with my subquery problem. it worked great. the problem I have now is that I need the same thing but need to be able to specify the start date of the year ie 01/06/02 to 31/05/03. also there may be more than one rate for each month, and I need to how the average rate for the month.

I have reattached the db you sent to me, and have include a the rates table I am using.

Hope you can help

Thanks
Geoff

 

[Jon K]

I have added a series of two queries in the database. You can run the second query.

In order to be able to sort the months properly, the month columns are displayed as

2002 06
2002 07
2002 08
.... etc