Removing duplicate entires from multiple queries

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

Guest

Question,

I have a query that's pulling info back from other queries that seperate out
overdue names for classes they need.

The query looks like this :

Math............English............History
Bob.............Steve...............Sara
Bob.............Tom.................Mary
Bob..............Sara................Mary
Bob...............Chris..............Steve


My question is, how do I get it to look like this:

Math............English............History
Bob.............Steve...............Sara
.............Tom...............Steve
..............Sara................
...............Chris..............


Thanks!
 
My question is, how do I get it to look like this:

Math............English............History
Bob.............Steve...............Sara
.............Tom...............Steve
..............Sara................
...............Chris..............
Click to expand...

By basing a Report on the query, and setting the textboxes to suppress
duplicates.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making Columns out of rows. 2
Create Table Query 10
Query to Change Tables 1
Multiple indexes 3
Query help to remove duplicates 3
Problem Sequentially Numbering Records 2
QUERY DESIGN HELP 2
a tricky selection query 4

Back
Top