Searching Access and showing all results on one page

[kevink]

Hello!<br>

<br>

I have a simple access database comprising of 3 fields - Name, File Number and description. The File number is an autonumber and is the primary key.<br>

<br>

The name could appear in several records e.g. Joe Bloggs appears in File number 001, 005, 013 etc.<br>

<br>

Is there anyway I can search for a name and bring up all the File numbers and descriptions associated with that name?<br>

<br>

I've tried using VBS and SQL but to no avail!!<br>

<br>

Thanks,<br>

<br>

Kevin.

 

[Zelandakh]

select<br>
name,<br>
filenumber,<br>
description<br>
from<br>
tablename<br>
where<br>
name = &quot;*&quot; & [Name Check] & &quot;*&quot;<br>
sort filenumber asc;<br>
<br>
?<br>