2 distinct fields (1 Viewer)

R

rex

Guest
Is it possible to run a query to select unique records based on the combination of two fields?
 

dcx693

Registered User.
Local time
Today, 07:58
Joined
Apr 30, 2003
Messages
3,265
Yes. Add the two fields to your query, then go to the View menu and choose Properties. In Unique Values, select yes.
 
R

rex

Guest
I have a table that tracks job positions. I keep the date, the department and the position. What I would like is if infomation is added but the person has the same position and department I would like to just display a brief overview.

Example
Date PayIncrease Salary % Bonus Date_ Program Position
5/ 1/2003 $0.00 $2,000.00 0.00% $0.00 Limited Internship Partnership Development
5/ 5/2003 $600.00 $2,600.00 23.00% $200.00 5/6/2003 Management and General Expense Administrative Assist.
5/ 6/2003 $0.00 $2,600.00 0.00% $0.00 Management and General Expense Administrative Assist.
5/15/2003 $0.00 $2,600.00 0.00% $0.00 Management and General Expense Administrative Assist.

For that data set I'd like it to read
Date PayIncrease Salary % Bonus Date_ Program Position
5/ 1/2003 $0.00 $2,000.00 0.00% $0.00 Limited Internship Partnership Development
5/ 5/2003 $600.00 $2,600.00 23.00% $200.00 5/6/2003 Management and General Expense Administrative Assist.
 

Users who are viewing this thread

Top Bottom