Selection

[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.Clark]

The quick and dirty way is to use a parameter:

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

 

[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.