Access

[Throrug]

Trying to make a test statistics sheet. where I show the avg passed, avg
failed, test avg, but I show this for different classes. I also pull charts
from this. I currently use excel but every time I have a new class which is
about every 3 months I have to start a new column on each tab

 

[John W. Vinson]

Trying to make a test statistics sheet. where I show the avg passed, avg
failed, test avg, but I show this for different classes. I also pull charts
from this. I currently use excel but every time I have a new class which is
about every 3 months I have to start a new column on each tab

STOP.

If you are adding a new field every time you add a new class, your database
design is *wrong*.

Tables are not spreadsheets; Access is not "Excel on steroids". It's
different, and requires a different structure and different logic!

See the tutorials at the end of this message, and/or post back with a
description of your Tables and how they are related.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials