Report prints out over n pages?

[bluedollar]

I have a report that is supposed to list the top ten quotes for a particular contract (which it does), however it prints exactly the same info over ten pages (not the one which was intended).

The list of quotes is a subform on the report, which is based on a query, which has the following sql:

SELECT TOP 10 quote.quote_num, quote.details, quote.contract_num
FROM quote
WHERE (((quote.contract_num)=[Forms]![main_contract]![Text125]))
ORDER BY quote.quote_num DESC;

Does anyone know what I am doing wrong?

Any help would be greatly appreciated.

Thanks

Dan

 

[RoyVidar]

Some thoughts/guesses:

Try placing the sub report in another section of the main report (I'm guessing detail section is current and it's perhaps linked to some part of mains recordsource).

If the top10 is the only thing you present, do you need the main/sub? If so, perhaps remove any linkage between main and sub, and also remove recordsource for main. I think this might work, since you get qriteria from a form.

If the main report displays project information, the top10 sub might for instance recide in mains page/report footer.

HTH Roy-Vidar

 

[RoyVidar]

Oups - did I read something wrong again, you're having a sub form on the report. Never tried that, did some testing, and I think some of the above might work...

If removing recordsource from main report isn't an option, try filtering it, so you only get current project record.

Roy-Vidar