Search results

So for example for one box, this is what I have. This data comes in from 4 subreports. Sometimes one of the reports will not have a number, and I want this new box on my main form to only divide by the number that has data in it. So say these four subreports, only 3 have a number 1 or...

Okay, here is a hard one. I am trying to get my report to divided numbers that are there. I get this data from subreports, then want it divided by the appropriate number. Example: 23 0 10 15 0 0 this would equal 48, but I want it to be divided by 3, not by 6. Or say the next report...

Is there a way to make invisible box, that would count and check each report to make sure there is a value and add these together. Then once that number was collected, say 3 or 4, with the possible of 6. Would only divide the totals by the 3 instead of the 6?? I am not sure if asking this...

Hey, I went back again like you said by looking at each thing, and found I was pulling from wrong fields. Got it to work. Thank you. I do have another question, but this one is harder, and will need to be walked through this. =(IIf([rptEmployEvaluationAuditor1...

You don't see that there is two data coming into this formula. Both information is coming from a subreport to create the information in the main report. One is coming from the Operator Report, the other is coming from the Operator Trainer Report. Taking these two numbers and getting an...

When I took each one separate, they both worked. But when I combine them, they don't????? Tony

I am trying to use this formula in my report, but I keep getting #Name? in the box instead of the number. =(IIf([rptEmployEvaluationOperator subreport].[Report].[HasData],[rptEmployEvaluationOperator subreport].[Report]![OperSP],0)+iff([rptEmployEvaluationOperatorTrainer...

Hey, almost forgot. =(IIf([rptEmployEvaluationOperator subreport].[Report].[HasData],[rptEmployEvaluationOperator subreport].[Report]![OPTotal],0)+IIf([rptEmployEvaluationOperatorTrainer subreport].[Report].[HasData],[rptEmployEvaluationOperatorTrainer subreport].[Report]![OPTotal],0))/2...

Hey, you are smart to me. Great job. Tony

Hey, figured what I did wrong, forgot the ( ). It works now. Hey thank you very much. I do not know what I would do with this Forum, you are all so great and smart. Tony

Okay, so far so good. On the first one I noticed that it is not doing the math correct. =IIf([rptEmployEvaluationOperator subreport].[Report].[HasData],[rptEmployEvaluationOperator subreport].[Report]![OPTotal],0)+IIf([rptEmployEvaluationOperatorTrainer...

Thank you, that worked for the first one. The second one, do not know if I am missing something. =(IFF([rptEmployEvaluationAuditor1 subreport].[Report].[HasData],[rptEmployEvaluationAuditor1 subreport].[Report]![OPTotal],0)+IFF([EmployEvaluationAuditor2...

Hello I am trying to get my totals from my subreports, and dividing the number by 2 or 4, and put the new number on the main report. for Operator/Trainer Productivity, I used: =([rptEmployEvaluationOperator subreport].[Report]![OPTotal]+[rptEmployEvaluationOperatorTrainer...

Thank you Minty, Everything is working great now. Thank you again for the help.

Each part has their Film Supplier listed, so for each part that is printed out, it would also show their Film Supplier. I think there is a conflict, because the Film Supplier is in the Parts Table, and they are both required to pull the part and film. I think that is why it is acting the way...

I think you were also right about this: (tblPartInfo.PartID = tblScrapLog.PartNumber) AND (tblPartInfo.PartID = tblScrapLog.[Film Supplier]) When I too the Film Supplier out, everything showed up. So I guess the next question would be how can I get the Film Supplier into my query without...

I had to ask the owner of the company about sending the db, they prefer not too because of the data that is in it. Darn, it would sure help if I could.

I did another test, where I went to the main page, and did a search between dates, and that did show everything.

I think you are right. I had made it where I just put in the date, and it still only brought some parts in, but the rest of them. I also tried a test, by just doing a small query where I just have the date and part number, and the same thing. So this seems it got something to do with not...

Yes. SELECT tblScrapLog.ScDate, tblScrapLog.Department, tblScrapLog.Shift, tblPartInfo.PartNumber, tblPartInfo.[Film Type], tblPartInfo.[Matl/Part], tblScrapLog.StUpMa, tblScrapLog.BadForm, [tblScrapLog]![THWeb]+[tblScrapLog]![Webs] AS Webs, [tblScrapLog]![THDirt]+[tblScrapLog]![Dirt] AS Dirt...