Search results for query: *

Thanks for all your help i figured it out... stupid problem on my part!! TOm

I am ultimately getting a data type mismatch I really am haviong an issue with getting the averages for any kind of query

SELECT Month([date]) AS dt_month, Avg(rates.[3_month_discount_rate]) AS AvgOf3_month_discount_rate, Avg(rates.[3_month_coupon_rate]) AS AvgOf3_month_coupon_rate, Avg(rates.[3_month_low_coupon_rate]) AS AvgOf3_month_low_coupon_rate FROM rates WHERE (((Month([date]))=[Please enter a month])) GROUP...

Thanks but now Im getting a message that it is too complex to be evaluated, and the expression is typed incorrectly Tom

Yeah it was a typo but that didn't work either.... Im stumped thanks for your help

Thanks alot Mike but it is giving me a syntax error, "missing operator in query expression" this is what my SQL reads: select month([date]) as dt_month,avg([3_month_discount_rate),avg([3_month_coupon_rate),avg([3_month_low_coupon_rate) from [rates] where month([date) = [Please enter...

I am trying to query the entries for a particular month in a table. My table consists of 4 colums, date, and 3 different interest rates. I want to be able to enter the month and the query generate rates for that month and average them. Any help would be great