help in monthly and yearly query

[anil]

hi all
i need advice in generating a result in the following format:

LOCATION-YEAR-MONTH-PARAMETER-MONTHLYRESULT-MAX.VALUE-YEARLYRESULT
abc - 2005 - 03 - red - 0.25 - 0.50 - 0.35

actually monthly result is the mean value recorded in month,yearly
result is maximum value recorded during preceding twelve months.also
month and year are from ''date on which sample was taken'' .
so i am in doubt that using the form and Date-Picker, i should select
the month and year and get the monthly and yearly result.But the
problem is - i need result only in monthly and yearly format not
between the two dates, because if some one selects end date as 30th of
7th month it will not end of month.so please can u suggest any method
where i could get only the month as well as year and respective result.
thanks
anil

 

[Alex Dybenko]

Hi,
you can use 2 comboboxes to select year and month, and then use DateSerial
function to build date value (or range) from selected year and month

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[anil]

hi alex
thanks for ur help.2 things to ask.
first year range is 1900-2200 , is it ok in combobox.
second dateSerial function returns date while i need the results for
last year.I am not interested in particular date but monthly and yearly
results only.
can u explain it in more detail.I think I am mixing somewhere.
thanks
anil

 

[Alex Dybenko]

Right, perhaps you don't need serial date.
Well, as I understand - you need to get monthly results, which are results
of grouping some table - right?
then you can add criteria to this query - and filter it by selected year and
month.

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com