Do not show a part of a record

[Guest]

I have a database of students in field placements. A student may have one or
two placements a quarter. I want to run a query that will show me all the
student who are doing a placement in columbus. The problem is, I have both
placements on the same table, and now I want the query to show me the
information only pertaining to the Columbus placement. When I run the query
with select criteria, I get the information I want, but if the student is
doing a columbus placement the second half of the quarter, then thier
non-Columbus placement shows up too... How do I get access to not show the
non-Columbus information in the query?

 

[[MVP] S.Clark]

Assuming that you have a column that denotes the location, you could do
something like:

Select * from tablename WHERE location = "Columbus"

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[Michel Walsh]

Hi,


The same record has two kind of information? it should get only one
kind of information. You probably have


StudentID, info1, loc1, info2, loc2, .... ' fields
joe, 1010, columbus, 1011, seattle, .... ' data


while it would have been preferable to have TWO records:

StudentID, info, loc
joe 1010 columbus
joe 1011 seattle

....


and then, "naturally", only the information about columbus would appear, not
the one about seattle.



You can use a UNION ALL query to normalize such a table.



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Etiquette suggests that you not post the same question to the same news group
two days in a row. A little patience is a virtue. This question was answered
yesterday and now again by Steve and Michel.