subreport add numbers to count

sunshine076

Registered User.
Local time
Today, 06:43
Joined
Apr 6, 2009
Messages
160
I am requesting some help. I have a database that is going to be linked to excel however, I cannot seem to figure out how to calculate one column total. Example I have one column with Void, NC, Scrap and need a total of each of these to go into the footer. I have followed several examples but it doesn't want to do it I keep receiving the #error. I decided to create subreports and place them in the footer however, I have found that with each subreport it is adding up to 10 and not the intended number such as 8 or 7. Any suggestions on how do resolve this issue?
 
Instead of subreports use the footer part again but

1. Make sure your fields are not named the same as the text boxes bound to them. So if you have a field named VOID then make sure the text box bound to that is named txtVoid and not Void, etc.

2. Then refer to the field names as the control source:

=Sum(Nz([Void],0))
 
Still receiving the #error my field name where Void, NC, and Scrap are located is called SorNC so my sum formula would be
=sum(sorNC([Void],0)) right?
 
Still receiving the #error my field name where Void, NC, and Scrap are located is called SorNC so my sum formula would be
=sum(sorNC([Void],0)) right?
Wrong. You should have fields named Void, NC, and Scrap. You would not have one field with them. If you do, you've set things up incorrectly.

And it should be this

for one text box control source
=Sum(Nz([Void],0))

For a second text box:
=Sum(Nz([NC],0))

And a Third Text box
=Sum(Nz([Scrap],0))
 
Would the setup change once I have created the fields using Y/N? The 0 would become N or do I keep it as is with the 0
 
Sorry, I don't understand. What do yes/no fields have to do with this?
 
I will get back with you. I just lost some of my changes. When I separate the one column into 3 Void, NC, Scrap I will set the fields to text and then the code that has been given should work right?
 
Can anyone help me with my problem. I seem to be doing things backwards. I have created my report but the columns will not add up for me.
 

Attachments

When you say that this database is going to be linked to Excel, what exactly do you mean by that?

The reason I ask is because it looks like there is a lot of opportuniy to normalize the data.
You may get more meaningful and easier reports out of it once normalized.
 
Data will be stored in excel and transferred to Access into a database as attached. What I am trying to do is just have a total of Void, NC, and Scrap. I have started to create the report as in the NCLOG the part that I am getting stuck on is adding up the three items above and then I want a running total from all three.
 
I have attached an updated version the table I am using is called NCLOG the column that I am having issues with is SorNC. This is a drop down menu in excel therefore there is no way that I can have separate columns to tally up how many non-conformances in Scrap, NC and Voids. Any help would be grately appreciated.
 

Attachments

I was able to figure out what I was doing wrong with my statement. Thank you for your help.:)
 

Users who are viewing this thread

Back
Top Bottom