Using Access, I want to run a report that if it finds dups it add

L

logical252

I have a report that counts records and sums up a column. Both are based on
the name of the bank. However, when it sees a dup bank I want it to print
bank once and count all those records as one.
 
G

Guest

It may be easier to do part of this in the query: you can group
and sum by bank, and the report just has to count.

However, you can also do it on the report. Create a group
on the bank, and move the count and sum out of the detail
section and into the group footer.

(david)
 
L

Larry Linson

I have a report that counts records and sums
up a column. Both are based on the name of
the bank. However, when it sees a dup bank
I want it to print bank once and count all those
records as one.
Click to expand...

What defines a "dup bank"? Records in relational tables are, by definition,
unordered. In Reports you order them with the Sorting and Grouping
properties, and all entries for the same-name bank would be brought
together.

Larry Linson
Microsoft Access MVP
 
L

logical252

Well I understand what you are saying, however the issue is, I have to group
by another field BEFORE I sort by Bank. When I set a second grouping by
Bank, it counts something weird and I have incorrect counts.
 
L

Larry Linson

logical252 said:
Well I understand what you are saying, however the issue is, I have to
group
by another field BEFORE I sort by Bank. When I set a second grouping by
Bank, it counts something weird and I have incorrect counts.
Click to expand...

Clearly, without detail (possibly 'excruciating' detail) we aren't going to
be able to be of much assistance. I suspect we will have to know the general
detail of the table/query layout that is RecordSource (including any
sorting, even though that sorting is completely overridden by the Report's
Sorting and Grouping), and the details of the Report's Sorting and Grouping.

But I still don't know what you mean by "dup bank" and "something weird" and
"incorrect counts" don't give us much of a hint.

Larry Linson
Microsoft Access MVP
 
Top