querying for records that are identical except for one field

[krazymonkeys]

Hi, please forgive me if I am asking something already answered. I am not even entirely sure of a proper title for what I am asking. I am a student with no prior experience with access and I haven't been able to get in touch with my instructor today. Basically, what I am looking at is I have a few entries I have to query for involving books with multiple authors. I can find which books have multiple authors as well as the second listed author, but I can't figure out how to get both authors to show up. The authors sequence is listed in the field "sequence" and the first author will have 1 as the entry and second will have 2. I get it to show the books with 2 authors by querying for sequence 2, but I can't figure out how to get it to show the same book's first sequence as well. I am guessing I should instead be somehow querying for duplicate entries in the title field but I haven't been able to figure that out either. I tried using the query wizard to search for duplicate entries, but being that the entries are not technically duplicate since the sequence field is different between the two, that type of query brings up no results at all. Please forgive me for coming here for this info, but I have been working on this question for a couple hours now and the homework is due tomorrow. Hopefully I'll get a response and in the mean time I'll keep trying. Thanks in advance.

[orange]

Please show us
- the sql of your query, and
- the design of your tables.

[June7]

Here is one possibility, something like:
SELECT * FROM table WHERE DCount("title","table","title='" & [title] & "'") > 1;
or
SELECT * FROM table WHERE DMax("sequence","table","title='" & [title] & "'") > 1;

Another involves aggregate query and joining table/query.
SELECT title, Count(title) As TitleCount FROM table GROUP BY title;
Now join that query to the table on the title fields and apply >1 criteria to the TitleCount field, like:
SELECT table.title, author FROM query1 INNER JOIN table ON query1.title = table.title WHERE TitleCount > 1;
The above as single nested query
SELECT table.title, author FROM (SELECT title, Count(title) As TitleCount FROM table GROUP BY title) As Query1 INNER JOIN Table ON query1.title=table.title WHERE TitleCount > 1;

Shooting from hip but hope it gives you guidance.