Counting in reports (2000)

Topic

New Reply

Hi, I have a query that returns all records from a series of one to many and many to many relations, so for instance I could have an ID of say A1 but that could have 4 risks types associated to it. In my query and report there are 4 records. I need a count type function that distinctly counts only counting the ID once, even though it occurs 4 times it distinctly only exists once.

Thanks, Darren.

Reply | Quote

Replies

If you group the report by ID, you can place a hidden text box txtRunningCount in the group header or footer with Control Source set to =1 and Running Sum set to Over All.

In the report footer, place a text box with Control Source =[txtRunningCount]

Reply | Quote

If you group the report by ID, you can place a hidden text box txtRunningCount in the group header or footer with Control Source set to =1 and Running Sum set to Over All.

In the report footer, place a text box with Control Source =[txtRunningCount]

Neat Hans, thanks, Darren.

Reply | Quote