show sum row only in report

mo7kenawy

New member
Local time
Today, 10:45
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: 135
In the report footer,put a box,
Set fproperty =sum(field)
 
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

Back
Top Bottom