show first few

[slimjen]

All using 2010. Have a report. I want to show the first few records but the total for all the records. Based on query; I ask for top 10. I tried "can't grow" in the properties. It gives me the first 10 records but only the total for the ten. How can i retrieve results I need. Thanks in advance

[slimjen]

Ok. No takers. Maybe I can write code to hide records greater than 10???
But How.

If me.control.value >10 then
me.control.visible =false

would hide all correct?

[Dal Jeanis]

First impression : Use two different subreports, one for the first ten and one (without detail) summarizing the whole set.

[June7]

Another possibility is domain aggregate function (DSum).

Or report/subreport as Dal suggested. Main report RecordSource could be an aggregate query. Subreport RecordSource would be the limited dataset.


I deleted the dup thread.

[slimjen]

how would the dsum work?

[June7]

The total for all records in table would be: DSum("fieldname","tablename").

Can apply filter criteria in the WHERE CONDITION arugument: DSum("fieldname", "tablename", "some field=" & some value)

Access Help has more info on domain aggregate functions.