show sum row only in report (1 Viewer)

mo7kenawy

New member
Local time
Today, 22:30
Joined
Aug 27, 2020
Messages
12
hi,

if I have a table I attached it and I need to make query

if NameCode Duplicated sum Number1 and 2 and 3 and query show all other table but in number1 and 2 and 3 show the result
 

Attachments

  • sum.png
    sum.png
    5.4 KB · Views: 89

Ranman256

Well-known member
Local time
Today, 16:30
Joined
Apr 9, 2015
Messages
4,339
In the report footer,put a box,
Set fproperty =sum(field)
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 16:30
Joined
Feb 19, 2002
Messages
42,974
Create a query that summarizes the data as you want to see it. Then use that query as the RecordSource for the report. If you've already built the report, the names of the bound columns will change so you'll have to fix them.
 

Users who are viewing this thread

Top Bottom