query and table not connecting

  • Thread starter Thread starter Hetty:)
  • Start date Start date
H

Hetty:)

Hello all,

I am creating a database for my schools detention system (its my A2 project).

I have created a select query to find the students in a form which i have
specified (in this case 7A) The result for the form 7A comes up with the
results that i need. I entered 7A's data directly into the student details
form i created earlier. I then entered 6As information into my student
details table and ran a query for 6A with the same built as the query for 7A.
no result. The new forms i entered (like 6A) are saved on my student details
form but do not appear in a query.

What am i doing wrong?

thank you,
Hetty, Bristol UK
 
Hello all,

I am creating a database for my schools detention system (its my A2 project).

I have created a select query to find the students in a form which i have
specified (in this case 7A) The result for the form 7A comes up with the
results that i need. I entered 7A's data directly into the student details
form i created earlier. I then entered 6As information into my student
details table and ran a query for 6A with the same built as the query for 7A.
no result. The new forms i entered (like 6A) are saved on my student details
form but do not appear in a query.

What am i doing wrong?

thank you,
Hetty, Bristol UK
Click to expand...

You're mixing levels.

Tables contain data, and you can base queries on tables.

Forms are just windows to display data in a query, or in a table. You can't
"find the students in a form" because the student information isn't IN the
form, it's in a table - the form's recordsource.

What are the Recordsource properties of these forms? What is the structure and
relationship of your tables? Do you actually have different forms for 7A and
6A (in which case you're really on the wrong track)?
 
Back
Top