• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

show sum row only in report (1 Viewer)

mo7kenawy

New member
Local time
Today, 11:38
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: 9

Ranman256

Registered User.
Local time
Today, 05:38
Joined
Apr 9, 2015
Messages
3,619
In the report footer,put a box,
Set fproperty =sum(field)
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 05:38
Joined
Feb 19, 2002
Messages
29,705
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