Query - Hiding Repeated fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
My problem is that i have a database with fields linked to each other (some
more than once). But in a particular query i have created showing all these
different fields linked to each other i have reapeated entries (because of
fields being linked to fields more than once). Is there any way i can just
show all the fields linked to each other ONCE? (Hiding reapeated entries)
 
John said:
Hello,
My problem is that i have a database with fields linked to each other (some
more than once). But in a particular query i have created showing all these
different fields linked to each other i have reapeated entries (because of
fields being linked to fields more than once). Is there any way i can just
show all the fields linked to each other ONCE? (Hiding reapeated entries)
Click to expand...

We can be more helpful if you post the SQL that you are asking about,
plus some example data (2-3 records) that illustrate what is wrong with
the SQL, plus a description of what you'd like the results of the Query
to look like.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
SELECT [Tutor Table].[Tutor ID], [Tutor Table].Title AS [Tutor's Title],
[Tutor Table].Surname AS [Tutor's Surname], [Tutor Table].Forename AS
[Tutor's Forename], [Student Table].[Student ID], [Student Table].Title AS
[Student's Title], [Student Table].Surname AS [Student's Surname], [Student
Table].Forename AS [Student's Forename]
FROM [Tutor Table] INNER JOIN ([Student Table] INNER JOIN [Booking Table] ON
[Student Table].[Student ID] = [Booking Table].[Student ID]) ON [Tutor
Table].[Tutor ID] = [Booking Table].[Tutor ID];

Tutor ID Tutor's Title Tutor's Surname Tutor's Forename Student ID Student's
Title Student's Surname Student's Forename
2 Mr Tilly Roger 1 Ms Sinclair John
3 Mr Freedman Alan 3 Mr Rendell James
2 Mr Tilly Roger 1 Ms Sinclair John


I would like the repeated data not be shown by this query. Here tutor ID 2
is matched with Student ID 1. However because this happens more than once in
the database, it is shown twice. I need the query to only show the matching
once.
 
Set "Unique Values" to "yes" in the query properties dialog. Double click in
an empty space within the top half of your query's "Design View," where the
table-relationships are displayed.
 
worked, thanks.

james said:
Set "Unique Values" to "yes" in the query properties dialog. Double click in
an empty space within the top half of your query's "Design View," where the
table-relationships are displayed.
Click to expand...
 
Back
Top