Greeting

I have a table for 50 employee and I need a way to search for 5 employees in
one go, is that possible??

Simple and dirty way - You can make a parameter query with 5 rows of
parameter criteria. Can't see how you would need to use it but maybe you
do.

Bonnie
http://www.dataplus-svc.com

Jon wrote:
>Greeting
>
>I have a table for 50 employee and I need a way to search for 5 employees in
>one go, is that possible??

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

This code is to filter a report, but it could be adapted to filter a form:
http://allenbrowne.com/ser-50.html

Another option would be to use a pop-up search form with five combo boxes
for selecting the five employees, then using those values as the criteria
for a query on which a form or report is based. If there could be fewer
than five employees you would need to allow for nulls.

In any case the table should not be opened and filtered directly. The
filtering (the selection of the five employees)should limit the record
source for a form or report.

"Jon" <Jon@discussions.microsoft.com> wrote in message
news:DA8997D5-812A-4441-8B5E-5FC4FD22CE4E@microsoft.com...
> Greeting
>
> I have a table for 50 employee and I need a way to search for 5 employees
> in
> one go, is that possible??
>

only if you move to SQL Server.

jet would probably throw a tissy with a query that complex




On Aug 12, 5:43*am, Jon <J...@discussions.microsoft.com> wrote:
> Greeting
>
> I have a table for 50 employee and I need a way to search for 5 employeesin
> one go, is that possible??

No matter the engine, the SQL needs to be properly designed. Since you are
unable to describe how to handle the SQL you should refrain from posting
replies, particularly since this is an Access newsgroup.

"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.com> wrote in
message
news:f93afb84-7f70-4dfc-bb11-b649d9643d51@i24g2000prf.googlegroups.com...
only if you move to SQL Server.

jet would probably throw a tissy with a query that complex




On Aug 12, 5:43 am, Jon <J...@discussions.microsoft.com> wrote:
> Greeting
>
> I have a table for 50 employee and I need a way to search for 5 employees
> in
> one go, is that possible??