Search results

I needed to display the stats but that is very helpful.

Solution..create blank report 1. Text box control. =DCount("*,"qry1") Name: Box 1 2.Text box control. =DCount("*,"qry2") Name: Box 2 3. Text box control. =[Box1]-[Box2] Name: Box3 4. Text box control. =[Box3]/[Box1] Name: Box 5 5. Convert Box 5 to percent.

Completed the line of work for report. Cant thank you enough. I know its basic but i have to go through the process and build it out so i can then maybe translate it into a better solution using VBA. You are all great and cant thank you enough.

The Dcount solution worked..thanks..glorious.

Ok. Didnt think it would be that easy. Thanks.

Not subreports.

Report 1. Has a count total field.(=Count (*) Report 2. Has a coint total field.(=Count (*) Report 3. Need to add a control to subtract both.

Anyone recall the control syntax to add two count records totals from two seperated reports into another report?

No Worries. I actually have SSRS installed and wanted to start using it. Do you know if it is difficult?

Looks like it may be for SSRS

This to save a $400 Adobe Acrobat license. Thanks for the info.

Very Happy Friday! I got some incredible support and guidance the past few weeks which was great in terms of motivation and helped lead me to very productive results. With that in mind, I am grateful and was able to create a very useful report containing about 6 reports all with charts etc...

Yes, the total comes from a count records query.

I figured out the data bars as well. THe problem I get when running comparing the records is "Cannot have aggregate function in expression (Min(Count(())) so perhaps I need to build a new query?

Mark - I found it was very good but hard to follow in terms of reports. I'll need a week to figure that out. Im just looking to apply bars to reports. I'm thinking the link will help and it is exactly what I need if it applies to 2013. I'll let you know how it goes.Thanks.

Wow, it was kind of easy. Thanks for your support. Do any of you know how to do a data bar?

Its about time I took my access skills to the next level.!

Oh that's beautiful. I can do the report quite easily just manipulating the different charts and I'll be there. I cant wait to figure this one out.

Missed a few lines: In previous versions, Access forms could be confi gured to show data in PivotTable and/or PivotChart view, which was effective for displaying multi-dimensional data or for rendering aggregated data in a visual manner. Both relied on Microsoft Offi ce Web Components, which...

Yes, exactly Ridders but on a report to integrate to a summary.