Please help update query

[Guest]

I have a table called classes in there I have a few fields called “day 1 day
2†and so on, in there I type “Yâ€, that means that they came that day and
then I have a field called “total days attended†how can I make that it
should count all the days attended ?

 

[Jeff Boyce]

Jone

If you have fields named "day1", "day2", ... "day N", you have ... a
spreadsheet! That's how you'd have to set up what you're doing if you were
limited to using a spreadsheet, but Access is a relational database. You
won't get the best use of Access' relationally-oriented features and
functions if you feed it 'sheet data.

Take a look into "normalization" to get ideas on how to set up your data to
make better use of what Access can do for you. Hint: think "tall &
skinny", rather that "short and wide" (thanks, JohnV.!)

You might want to use the following links to learn more:

Jeff Conrad, Access Junkie
http://www.accessmvp.com/JConrad/accessjunkie.html

Data Normalization Fundamentals by Luke Chung
http://www.fmsinc.com/tpapers/datanorm/index.html


--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/