I have a couple of related dbs - one containing a list of classes (this is for a horse show) with various info including day of the week & session time; one containing participants entered in each class. (there's also another related db containing participant info).

I need to generate a report on a daily basis that will show each class scheduled for that day & session time (two session times per day) and the number of participants entered in each class. I want those classes that have no participants entered to show as '0'.

I have played w/the count(field) but have not come up with anything that gives me what I want. I bet it's really simple & I have a block. (maybe it's not a script??)

Any help will be greatly appreciated! I have attached both dbs in the zip file with this post. You may notice by the dates that this is time critical (naturally!)

Thank you!

Martie

for forum.zip

Nevermind!~ - just needed a good night's sleep - it wasn't a script I needed but rather a calculation - all is well.