Please help update query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jone - 20 Nov 2007 00:29 GMT

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 ?

Reply to this Message

Jeff Boyce - 20 Nov 2007 01:51 GMT

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

Signature

Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

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

> 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 ?

Reply to this Message