Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Report Grouping

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
brobb - 15 Oct 2007 00:25 GMT
I have a report that tells that is grouped by jobs and then expenses, income
and total in a sum query. I have 4 accounts listed in the table. I want the
report to give me sums of expenses and income per account and then sum total
of job. Can anyone help me?
Ken Snell (MVP) - 15 Oct 2007 01:40 GMT
Add a textbox to the Group Footer section for the Account field's
"grouping", and put an expression in its Control Source to Sum the
appropriate field.

Signature

       Ken Snell
<MS ACCESS MVP>

>I have a report that tells that is grouped by jobs and then expenses,
>income
[quoted text clipped - 3 lines]
> total
> of job. Can anyone help me?
brobb - 15 Oct 2007 03:04 GMT
Thank you so much for your response. I am self taught in Access and I do not
know how to add this text box. I hate to impose further but can you tell me
how to do that.

> Add a textbox to the Group Footer section for the Account field's
> "grouping", and put an expression in its Control Source to Sum the
[quoted text clipped - 7 lines]
> > total
> > of job. Can anyone help me?
Tom Wickerath - 15 Oct 2007 08:48 GMT
Display the field list, if it is not already displayed: View > Field List
Drag a field from the field list, and drop it onto your report.

You may need to first create the appropriate Group Header and Footer for the
field in question, or perhaps just display a group Footer if the appropriate
Group Header is already shown. For example, if your report is currently
grouped by accounts, but you do not see a corresponding group footer for
accounts, then you will need to add one. To do this, click on View > Sorting
and Grouping in report design view.

You can add an unbound text box (ie. a text box that has no field specified
as it's Control Source) to the Accounts footer section. One way of doing this
is to first display your tool box, if it is not already displayed: View >
Toolbox. Your toolbox may be free floating, or it may be docked. Hover over
the various controls indicated in your toolbox, until you see a tool tip that
indicates Text box (ab|). Drag a text box to the Accounts footer section. Set
it's control source to an expression that involves the appropriate field name
that displays numeric data:

   =Sum([FieldName])

where you substitute FieldName above with the actual name of your field.

Here is an overview on creating reports (45-55 minutes) that you might find
helpful:

   http://office.microsoft.com/training/training.aspx?AssetID=RC010780631033


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

> Thank you so much for your response. I am self taught in Access and I do not
> know how to add this text box. I hate to impose further but can you tell me
> how to do that.
brobb - 15 Oct 2007 16:37 GMT
This did not give me result I wanted I currently have the report grouped by
job I have this information displayed

Job

Income (sum of all accts)         Expenses (sum of all accts)    Total (sum
of all accounts)

I want

Job

Acct 1      Income (sum of account 1)   Expenses (sum of Acount 1)
Acct 1      Income (sum of account 2)   Expenses (sum of Acount 2)
Acct 1      Income (sum of account 3)   Expenses (sum of Acount 3)
Acct 1      Income (sum of account 4)   Expenses (sum of Acount 4)
Summed total of all accounts income less expenses

> Display the field list, if it is not already displayed: View > Field List
> Drag a field from the field list, and drop it onto your report.
[quoted text clipped - 34 lines]
> > know how to add this text box. I hate to impose further but can you tell me
> > how to do that.
Tom Wickerath - 15 Oct 2007 17:01 GMT
It appears as if you need to add an additional level of grouping for Account
number. Did you mean to indicate Accounts 2, 3, and 4 instead of Account 1 in
each case? Use View > Sorting and Grouping in report design view to add a
group header and footer for Account below your existing grouping for Job.
After dismissing this dialog, add an unbound text box to the new group footer
for the Account with expressions that sum the appropriate numeric fields as
indicated previously.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

> This did not give me result I wanted I currently have the report grouped by
> job I have this information displayed
[quoted text clipped - 13 lines]
> Acct 1      Income (sum of account 4)   Expenses (sum of Acount 4)
> Summed total of all accounts income less expenses
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.