Selection

  • Thread starter Thread starter Pedro
  • Start date Start date
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
 
The quick and dirty way is to use a parameter:

Select Employee, Claim from TableName
WHERE Employee= [Enter Employee Number]
 
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.
 
Back
Top