Ian

You're welcome to mail a copy of your workbook to me,
and I'll give it a try.

Remove NOSPAM from my address.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Ian Jones" skrev i en meddelelse
...
Thx for your help Gary.
I can see what you are saying but each event has different forms with
their
own qualifying distances and records on them. also the track, highjump,
longjump and throwing events have different formats. We have 5 different
grades, elementary thru to senior. The way i do it now is filter say
highjump, girls, junior copy. then do the boys then change to the next
grade.
but if i could have formula in each form which looks up if the highjump
column if=1 and gender column=girls and grade=junior and listed them all
in
the form it would be fantastic. do you think its possible? thx ian

"Gary Brown" wrote: