I am using Access 2000.

Currently, I have the following table:

tblPointsChart
PointsNum_pk
EntryCountMin
EntryCountMax
PlacementNum
Points


It is used to assign points based on:

tblShowClassEnt ry
ShowClassNum_fk
EntryNum_fk
PlacementNum_fk

and qryEntriesPerCl ass that returns the number of entries in a class....