Query

[Guest]

I have a table which diplays field placements for education candidates. One
student may have 1 or more placements in the same quarter in the same or
different school districts. If the student has 2 placements then I have
identical fields for each placement named placement 1 and all corresponding
data and then placement 2 and all corresponding data. Now I want to run a
query that will show me the location for columbus placemnts irregardless if
it is placement 1 or 2, but I only want the query to show me the information
for columbus. What do I do?

 

[Guest]

Assuming that Columbus is a school district and that you have a school
district field in your table, you would set a Criteria of "Columbus" for the
[School District] field (or whatever it might be named). The SQL would look
something like:

Select * from YourTable as YT where YT.[School District] = 'Columbus';

I'm concerned about your statement:

"If the student has 2 placements then I have identical fields for each
placement named placement 1 and all corresponding data and then placement 2
and all corresponding data."

Do you mean to say 'record' rather than 'field'? If you really meant
'fields' than this is not a good path to go down. What happens if a student
has more than two placements in a quarter? How do you account for that? You
say 'one or more placements per quarter' which implies that this might be an
open-ended value. Surely your table is not full of blank fields just waiting
for some lucky candidate to have 10 or 20 placements in the quarter?

I don't even want to mention the other possible interpretation that came to
mind... <g>

Good Luck!