Linking multiple queries to one form

[Menno]

I'm trying to connect multiple queries into one form. Structure of the queries is as follows

ID	cat	Result
1	1	5
2	1	6
3	etc.	etc.

ID	cat	Result
1	2	8
2	2	10
3	etc.	etc.

The form should then be capable of filling in the results for each ID and for each category. Something like this:

ID	Query1 Result	Query2 Result	Queryn Result
1	5	8
2	6	10
3

As soon as I seem to connect the two queries to one form, I am no longer able to edit the results scores (not sure why). Any suggestions?

Menno

ps Not sure wheather this is a reasonable question, please don't hesitate to tell me if it isn't

[orange]

You are telling us HOW you are doing something. Can you describe to us WHAT you are attempting to do -- in plain English?

[Menno]

You are telling us HOW you are doing something. Can you describe to us WHAT you are attempting to do -- in plain English?

Thanks for your reply; I will try...

This is all about trying to collect a number of sub-scores (the results of test1, test 2, etc) for a group of students in such a way that I can later easily calculate the average score over a (variable) number of tests. I.e. I might need the average over test1 to test12, or maybe test4 to test9. The dataset might be incomplete for some students which should not result in a default score.
This can be easily achieved by collecting all the data into one table where I connect the StudentID with the testId and the TestResult. I can then compute the average by selecting the right tests in a query. (maybe my solution is very naïve, please tell me if it is).
However, I've run into trouble when I tried to create a form that shows an ("excel style") table where teachers can enter the results for those tests that were taken by a specific student. Does this clarify my problem?

Menno

[orange]

There are many Students
There are Many Tests
Many Students take Many Tests
A Student receives A Mark on a given Test

So you have at least 3 tables (maybe 4)

Student (studentId,Name,...etc student specific info)

Test (testId,TestName,,other test specific info )

StudentTookTest (studentID, testID, testDate, MarkReceived, and anythiing else specific to that Student and that Test on that Date)

If you deliver the same test multiple times you may consider a TestSession (being very picky)
[much like a Course eg Algebra 100 being taught 3 or 4 times a week where each "session" is uniquely identified]

Good luck with your project

[Menno]

There are many Students
There are Many Tests
Many Students take Many Tests
A Student receives A Mark on a given Test

So you have at least 3 tables (maybe 4)

Student (studentId,Name,...etc student specific info)

Test (testId,TestName,,other test specific info )

StudentTookTest (studentID, testID, testDate, MarkReceived, and anythiing else specific to that Student and that Test on that Date)

If you deliver the same test multiple times you may consider a TestSession (being very picky)
[much like a Course eg Algebra 100 being taught 3 or 4 times a week where each "session" is uniquely identified]

Good luck with your project

I fully agree with your structure (it is exactly what I created). Nevertheless, it doesn't solve my problem of wanting to create one form where I can see all students and then enter the results of all tests. I do realise that the problem probably lies in my problem definition, rather than your explanation.

[orange]

My comments were for getting the appropriate tables in the database.

You say you want to enter data for test results - how did you get whatever info/data you have into the database?

Queries would be used to select data stored in your table(s) and present it iin some format.

Queries could be the row source for combo boxes on a form.

Here's a link with quick entry form info.
http://www.techrepublic.com/article/...-entry/5710170