General vba help

[anil]

Hi all
i am designing a database to get monthly and yearly result.The out put
seems as
TOWN YEAR MONTH PARAMETER YEARLYRESULT
A,B,C 2001 2 x 100%(total pass results)
A,B,C 2001 2 y 0.3(Formula used on mean values)
A,B,C 2001 2 z mean value(5.1) AND SO ON
Thus I have to get monthly and yearly result of parameter x,y,z.In
Monthly results we have to compare with their fixed value i.e if x has
2,3,6 and pass value is 5 then only 2,3 are considered as results(mean
value) and also need to write 1 fail value as seperate column.

So one town has different parameters and all parameters have different
calculations.
Can someone help me that how can I proceed.I know this can't be done in
queries and i am not much proficient in vba.
thanks
anil

 

[Larry Daugherty]

Stop! Take a deep breath and start over. Print your post and hand it
to a few colleagues who are reasonably intelligent but not necessarily
involved in your immediate issue. Ask them to feed back to you the
meaning of your post.

If you want to get some help you'll have to explain your issues with
such clarity as they might be understood. Don't encode things with
the idea that so doing makes it look al "techie" and properly complex.
Doing that wastes your time and the time of anyone who would help you.

Post back with clarity and in detail and someone will pick up the
thread and help you. I realize that we have a large component of ESL
folks here and they are most welcome. But sloppy grammar and syntax
only add to the difficulty of helping you.

HTH

 

[anil]

hi larry
sorry,u cannot understand the problem,but u r right.I should post and
hand it to intelligent colleagues and then post here so that it might
be well understandable.
thanks
anil