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]
 
Back
Top