M mo7kenawy New member Local time Today, 10:45 Joined Aug 27, 2020 Messages 12 Sep 5, 2020 #1 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 5.4 KB · Views: 135
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 Well-known member Local time Today, 04:45 Joined Apr 9, 2015 Messages 4,354 Sep 5, 2020 #2 In the report footer,put a box, Set fproperty =sum(field)
P Pat Hartman Super Moderator Staff member Local time Today, 04:45 Joined Feb 19, 2002 Messages 47,521 Sep 9, 2020 #3 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.
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.