how to look for more that one record?

[Jon]

Greeting

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

 

[BruceM]

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.

 

[a a r o n . k e m p f]

only if you move to SQL Server.

jet would probably throw a tissy with a query that complex

 

[BruceM]

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.

message
only if you move to SQL Server.

jet would probably throw a tissy with a query that complex

 

[a a r o n . k e m p f]

Bruce;

go and play with your QBE, crybaby

SQL Server rocks. I will not let you nor anyone continue to post mis-
information without corrections.
Remember the MVP dipshit that INSISTED that people not use INT, BIGINT
or UNIQUEIDENTIFIER?

you can thank him for my presence.

I just won't put up with a bunch of lamers spreading lies about SQL
Server.
Sorry that Jet ****ing sucks.

But spreading lies about SQL Server isnt the solution.

Maybe you hairy mother ****ers should build a time machine and make
Microsoft fix a hundred jet bugs (namely, corruption-- any flavor) a
decade ago.
Until then-- **** jet.

-Aaron