Recent content by tafnuef1

ALSO.. if I can sum a few columns.. How would I tell it to Page Break on a change in a certain field? If this is possible?

Ok, I have a report.. I gave up trying to bring Counts from the Subreport to Sum on the Main Report. Seems many folks are having issues doing that. SO what I have decided to do is when I run my Access report it will automatically open up as a Excel worksheet. OK That part.. I got.. by Opening...

Never mind I got it to work with this: =IIf([Document Count Summary subreport].[Report].[HasData]=True,[Tot Prep Err]/[Document Count Summary subreport].[Report]![TotDocCount],0) Yay!:D

Ok, I have two fields Field 1 is in a subreport (Document Count Summary subreport) and it is called TotDocCount" and if it "HasData" then I want to Divide Field 2 that is called "Tot Prep Err" by Field 1 on the main report to create a percentage rate. If there is no data to divide I want the...

ok, can you give me an idea of what a stripped down version would be? How does most folks do that. Sorry I am such a newbie!

I tried that.. put it in every footer but would not work???

Ok I have a subreport... I have a Count called "AccessTotalsPrepper Error". I am counting the number of errors found in a batch audit. So on my main report I know I need to create a textbox to pull that data to sum up the counts. In that text box I have the source code set as =Sum([Prepper...

Actually once I started doing this I realized I need to SUM the Counts of Errors PER Batch. So in the example above if Batch numb 999999 has 3 errors and Batch Number 8888 has 3 I want to sum up the total amount of errors for that PREPPER. I want to SUM it but of course Access won't let me...

So in my below sample, where I am calculating the individual error count for a batch I then create another count in the footer that counts that contol box too? I have tried that before and not sure it works but I will try it again. Example: Prepper Name: Mickey Mouse Batch Number ID: 99999999...

Ok, how would I do this? I have a Query (Prepper Error Table Query) that pulls this data: BatchNumber ID Prepper Error Prepper Name Prepper Doc type I have a subreport (Error Counts) where I need to subtotal the total amount of errors per Batch Number ID So In my report(Error Counts) I...

Ok on my report I have a control called Prepper Errors. I have another Control that counts the number of Prepper Errors per Batch Number ID. For Example> "Prepper Name" may have 5 Batches and we are counting each error in each Batch. so for Batch Number 1 I have counted 5 errors...

Would this be what you would do? And how would you do it? right click the control and choose to Build Event and place it in there? Private Sub Total_Error_Count_BeforeUpdate(Cancel As Integer) If Not Me.Prepper_2_Query_Detail.Access_Totals_Prepper_Error Then nnz = 0 Else...

Ok, I have a Main Report currently named Prepper, I have a Subreport named Prepper 2 Query Data. In the subreport there is a control that is a calculated Count of another control on the sub report (Prepper Error) the calculation is counting the number of Prepper Errors. Ok that works fine...

Ok, look at this report I have created. Tell me how can I get one single total per Batch Number ID? As you see here it adds a total per error. In some cases a user will have several batch number IDs with several errors and I want to total each document count in each individual Batch number Not...

This is what it looked like before I added anything.. so how should it look if I want a Select Distinct of Document Count and grouped by Batch number ID? SELECT [DIQA Query].[Batch Number ID], [DIQA Query].[Document Count] FROM [DIQA Query];