By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Help with Access Design View

P: n/a
I am attempting to create a report with sub-totals in the body of the
report and a total at the bottom.
how do I go about doing this thanks:

here is an example of the result I need to achive

Style: Majest
1002 Brown, Ed 0 10 13 14
1005 Judy, Larry 10 17 7 10
1007 King, James 28 0 5 5
Subtotal for Style: 38 27 25 29

Style: Paris
Grand total : Total of all styles . 60 80
700 46

Thanks!

Nov 28 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You need to create a group in the report. However, Access needs a way to
tell how to group your data. It appears that you are using the first 3
numbers in the field Style, so create a field that contains this information.
One way to do this is to modify the underlying query by adding a calculated
field:

StyleSort: Left([Style],3)
Then use this new field in the report to create your groupings.

You can also do this directly in the report by creating a new group: =Left(
[Style],3)
Then add a Group Footer with fields that calculate the totals.

Seyi1 wrote:
>I am attempting to create a report with sub-totals in the body of the
report and a total at the bottom.
how do I go about doing this thanks:

here is an example of the result I need to achive

Style: Majest
1002 Brown, Ed 0 10 13 14
1005 Judy, Larry 10 17 7 10
1007 King, James 28 0 5 5
Subtotal for Style: 38 27 25 29

Style: Paris

Grand total : Total of all styles . 60 80
700 46

Thanks!
--
Message posted via http://www.accessmonster.com

Nov 28 '06 #2

P: n/a
Thanks... How add a Group Footer ?
kingston via AccessMonster.com wrote:
You need to create a group in the report. However, Access needs a way to
tell how to group your data. It appears that you are using the first 3
numbers in the field Style, so create a field that contains this information.
One way to do this is to modify the underlying query by adding a calculated
field:

StyleSort: Left([Style],3)
Then use this new field in the report to create your groupings.

You can also do this directly in the report by creating a new group: =Left(
[Style],3)
Then add a Group Footer with fields that calculate the totals.

Seyi1 wrote:
I am attempting to create a report with sub-totals in the body of the
report and a total at the bottom.
how do I go about doing this thanks:

here is an example of the result I need to achive

Style: Majest
1002 Brown, Ed 0 10 13 14
1005 Judy, Larry 10 17 7 10
1007 King, James 28 0 5 5
Subtotal for Style: 38 27 25 29

Style: Paris

Grand total : Total of all styles . 60 80
700 46

Thanks!

--
Message posted via http://www.accessmonster.com
Nov 29 '06 #3

P: n/a
I meant How do i add a group footer
Seyi1 wrote:
Thanks... How add a Group Footer ?
kingston via AccessMonster.com wrote:
You need to create a group in the report. However, Access needs a way to
tell how to group your data. It appears that you are using the first 3
numbers in the field Style, so create a field that contains this information.
One way to do this is to modify the underlying query by adding a calculated
field:

StyleSort: Left([Style],3)
Then use this new field in the report to create your groupings.

You can also do this directly in the report by creating a new group: =Left(
[Style],3)
Then add a Group Footer with fields that calculate the totals.

Seyi1 wrote:
>I am attempting to create a report with sub-totals in the body of the
>report and a total at the bottom.
how do I go about doing this thanks:
>
>here is an example of the result I need to achive
>
>Style: Majest
> 1002 Brown, Ed 0 10 13 14
> 1005 Judy, Larry 10 17 7 10
> 1007 King, James 28 0 5 5
> Subtotal for Style: 38 27 25 29
>
>Style: Paris
>
Grand total : Total of all styles . 60 80
>700 46
>
>Thanks!
--
Message posted via http://www.accessmonster.com
Nov 29 '06 #4

P: n/a
Never mind I have been able to figure it out.

Thanks!
Seyi1 wrote:
I meant How do i add a group footer
Seyi1 wrote:
Thanks... How add a Group Footer ?
kingston via AccessMonster.com wrote:
You need to create a group in the report. However, Access needs a way to
tell how to group your data. It appears that you are using the first 3
numbers in the field Style, so create a field that contains this information.
One way to do this is to modify the underlying query by adding a calculated
field:
>
StyleSort: Left([Style],3)
Then use this new field in the report to create your groupings.
>
You can also do this directly in the report by creating a new group: =Left(
[Style],3)
Then add a Group Footer with fields that calculate the totals.
>
Seyi1 wrote:
I am attempting to create a report with sub-totals in the body of the
report and a total at the bottom.
how do I go about doing this thanks:

here is an example of the result I need to achive

Style: Majest
1002 Brown, Ed 0 10 13 14
1005 Judy, Larry 10 17 7 10
1007 King, James 28 0 5 5
Subtotal for Style: 38 27 25 29

Style: Paris

Grand total : Total of all styles . 60 80
700 46

Thanks!
>
--
Message posted via http://www.accessmonster.com
Nov 29 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.