show sum row only in report (1 Viewer)

[mo7kenawy]

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

 

[Ranman256]

In the report footer,put a box,
Set fproperty =sum(field)

 

[Pat Hartman]

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.