Selection

P

Pedro

Hi,

I have a table that contains an employee code e his claims data in a year.
Like that:
Employee
00000001 Medical Consulting
00000001 Exam
00000002 Exam
....

And i need to create a Querie that ask which employee do you want to see,
and than shows his claims data.

Thanks
 
S

S.Clark

The quick and dirty way is to use a parameter:

Select Employee, Claim from TableName
WHERE Employee= [Enter Employee Number]
 
J

Jerry Whittle

In Query SQL design view, put in something like below:

SELECT [Employee], [Claims]
FROM YourTable
WHERE [Employee] = [Enter Employee Number] ;

You need to put in the correct table and field names.
 
Top