Want to show only 1 record in report

[Shannon3778]

I have a report with 3 fields in it. I have made the control source for each field an average of the #'s in the field of the query. I only want it to show 1 record but can't seem to figure out how. I've already listed the cycle option to current record, but it still shows the 3 fields repeating over and over... for ex:

Field 1 Label 7.4
Field 2 Label 8.4
Field 3 Label 6.4

Field 1 Label 7.4
Field 2 Label 8.4
Field 3 Label 6.4

And it goes on and on like this... the averages are correct, but I only want to show them 1 time, not repeatitively... HELP?!!? :banghead:

 

[mikeyplop]

Hi, Are you only after the 1st record? If so, you can open the query that the report is based on in SQL view and type "TOP 1" at the start of the SQL. This will bring back only the first record. Cheers, Mikey