A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report Totals



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2010, 04:11 PM posted to microsoft.public.access.gettingstarted
Georgethefence
external usenet poster
 
Posts: 1
Default Report Totals

Can anyone help me please. I'm totally new to Access 2007 but have started to
design a database for my husbands shed business.
I have an Orders Table and a Supply Table. There may be several supply
instances to complete one order.
The report which I'm having problems with is Orders Part Supplied. I've
summarised the important fields below. The report is grouped on Order No.

Order No Qty Date Supp'd
Qty Supp'd Total Qty O/S

10145 12
15/05/10
2
16/05/10
2

------------------ ----------------------

4

I have tryed lots of ways to get a Total Qty O/S but to no avail. Any
suggestions would be gratefully received.

  #2  
Old May 18th, 2010, 03:21 AM posted to microsoft.public.access.gettingstarted
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Report Totals

I can't discern you table structure or data from the posting. I'm not sure
what you tried or what you want to display in the report.

--
Duane Hookom
MS Access MVP


"Georgethefence" u60128@uwe wrote in message news:a824d80edbd64@uwe...
Can anyone help me please. I'm totally new to Access 2007 but have started
to
design a database for my husbands shed business.
I have an Orders Table and a Supply Table. There may be several supply
instances to complete one order.
The report which I'm having problems with is Orders Part Supplied. I've
summarised the important fields below. The report is grouped on Order No.

Order No Qty Date Supp'd
Qty Supp'd Total Qty O/S

10145 12
15/05/10
2
16/05/10
2

------------------ ----------------------

4

I have tryed lots of ways to get a Total Qty O/S but to no avail. Any
suggestions would be gratefully received.

  #3  
Old May 18th, 2010, 05:39 AM posted to microsoft.public.access.gettingstarted
Georgethefence via AccessMonster.com
external usenet poster
 
Posts: 2
Default Report Totals

I'm sorry. After previewing the thread layout my report text was clipped and
I agree even I can't understand the report from that. Sorry for the confusion.

Fields on report a
Order No (grouped)
Order Qty
(Both fields are in Orders Table)
Date Supplied
Qty Supp'd
(Both Fields are in Supply Table)
Total Qty O/S
This is the field I'm having trouble with. There may be several Supply
entries against one order. I need to display a total which takes the Order
Qty and minuses the Total Supplied from that.
Many thanks for your help.
Duane Hookom wrote:
I can't discern you table structure or data from the posting. I'm not sure
what you tried or what you want to display in the report.

Can anyone help me please. I'm totally new to Access 2007 but have started
to

[quoted text clipped - 19 lines]
I have tryed lots of ways to get a Total Qty O/S but to no avail. Any
suggestions would be gratefully received.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1

  #4  
Old May 19th, 2010, 04:18 AM posted to microsoft.public.access.gettingstarted
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Report Totals

I assume there are no subreports in this report. You should be able to add a
text box to the Order group footer with a control source like:
=[Order Qty]-Sum([Qty Supp'd])

--
Duane Hookom
MS Access MVP


"Georgethefence via AccessMonster.com" u60128@uwe wrote in message
news:a82be5f9a796a@uwe...
I'm sorry. After previewing the thread layout my report text was clipped
and
I agree even I can't understand the report from that. Sorry for the
confusion.

Fields on report a
Order No (grouped)
Order Qty
(Both fields are in Orders Table)
Date Supplied
Qty Supp'd
(Both Fields are in Supply Table)
Total Qty O/S
This is the field I'm having trouble with. There may be several Supply
entries against one order. I need to display a total which takes the Order
Qty and minuses the Total Supplied from that.
Many thanks for your help.
Duane Hookom wrote:
I can't discern you table structure or data from the posting. I'm not sure
what you tried or what you want to display in the report.

Can anyone help me please. I'm totally new to Access 2007 but have
started
to

[quoted text clipped - 19 lines]
I have tryed lots of ways to get a Total Qty O/S but to no avail. Any
suggestions would be gratefully received.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1

  #5  
Old May 19th, 2010, 05:32 AM posted to microsoft.public.access.gettingstarted
Georgethefence via AccessMonster.com
external usenet poster
 
Posts: 2
Default Report Totals

It worked. Thanks very much for your help. Now I can get on with the next
stage.

Duane Hookom wrote:
I assume there are no subreports in this report. You should be able to add a
text box to the Order group footer with a control source like:
=[Order Qty]-Sum([Qty Supp'd])

I'm sorry. After previewing the thread layout my report text was clipped
and

[quoted text clipped - 22 lines]
I have tryed lots of ways to get a Total Qty O/S but to no avail. Any
suggestions would be gratefully received.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.