Hi ADezii
The Student table is called 010t_children, important field names are child_id (an automatically generated unique number), first_name, last_name, dob (dd/mm/yyyy), start_date (dd/mm/yyyy). The Test table is called 020t_test, important field names are test_id (an automatically generated unique number), child_id (linking it to the 010t_children table), read_raw_score (a positive integer relating to their score on the test),...
Tom Travell
Last Activity: Dec 3 '10, 11:20 PM
Joined: Dec 1 '10
Location:
-
Need a query to return one date and the previous date only
Hi
I have a database which records students and their test scores. Each student could have between two and ten tests. The test are in one table and the students in another.
I want to create a query which will allow me to compare results between tests the student has taken. Unfortunately the database was set up with all the tests having the same name, so the only thing that varies between them is the date and the score....
No activity results to display
Leave a comment: