filtering query

i have two primary groups of information:
computer name
patch version

with two secondary groups of info:
date acquired
notes

these groups are in different tables, tho if i need to i can change that...

i am trying to keep a running database of what computers have what patches applied to them. i need the information displayed in a form or query format that will list all the patches that the computer has received, while only listing the computer name once.

say comp 1 has 3 out of the 5 patches
while comp 2 has 5 out of 5.

instead of:

comp 1 patch 01
comp 1 patch 02
comp 1 patch 05
comp 2 patch 01
ect,ect,ect

i want:

comp 1 patch 01
patch 02
patch 05
comp 2 patch 01

what are some options for me to do this?

Easiest way of doing it is to display in a form or report and set PC Name as a sorting group. Either do it through the view menu or just use the wizard.

right, this is an example of what i showed in my example 1. what i need is the displayed info to show up like example 2.
only displaying one machine name entry, while displaying all the patches.
machine 1 patch 1
patch 2
patch 3
machine 2 patch 3
patch 4
...and so on...

Yeah, do it through group headings. Put the PC Name label in Page header, PC name box in PC Name Header and the rest in detail

so you are just saying placement on the form will give the no repeat function not any specific code?