Changing dates in a MS Access DB

[Guest]

I have a student database which I would like to be able to get different data
for each school year from, it's a DB mostly based on pulling out statistical
data, not so much about the actual individual student.

For example, they want to be able to look at the information in the database
for this year, but next year they want to be able to only look in the
database at relevant information for next year, they don't want to pull the
statistics from old students next year, they also want to though be able to
go back to last years students and compare statistics, so for example, in
2007 there were 57 students of those 75% have ADHD but in 2008 there are 62
students with 83% with ADHD. What would be the best way of doing this, is it
better to simply create the same database named for the year and put all the
new students into that for next year or try and incorporate it all into one
database?

 

[Guest]

Use a single DB with a students table that includes a year field. Then,
write queries that include criteria for whichever year of students you desire.

Example table might have:
YEAR
LAST NAME
FIRST NAME
MIDDLE INITIAL
ADDRESS
GPA
etc.

Example query:
SELECT * FROM STUDENTS WHERE (YEAR = '2007');

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is an Access tutorial called
"Class Information Database" which walks you through the process of creating
such a database. You can find it here:
http://www.rogersaccesslibrary.com/TutorialsDesign.html. There is a
matching Application Design Tutorial that walks you through the process of
creating the application:
http://www.rogersaccesslibrary.com/TutorialsApplication.html

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

OK, I've added the year field, how can I get a query to prompt the user for
the year date?

Monique

 

[George Nicholson]

SELECT * FROM STUDENTS WHERE (YEAR = [Please enter year]);