Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print the top 4 value

Status
Not open for further replies.

kirk6772

Instructor
Feb 19, 2005
2
IT
I want to construct a report with the top 4 values from a table

If the structure of the table is:

IDTAb Field

01 123
02 222
03 444
04 555
05 456
06 999

the result report that I would want is:

field1: 123
field2: 222
field3: 444
field4: 555



how i could resolve the problem?
 
What is that defines the top 4? (How does a record qualify as being in the top 4?)
 
I have a Form with two Combo box
combo1 - combo2 And one Command Button

the values of the two combo determined the record to visualize in the report
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top