Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 11-10-2016, 04:00 PM   #1
Newly Registered User
Join Date: Nov 2016
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Jomer is on a distinguished road
Count and Summary multiple in reports

Hi all,

Im just new here and also using access.. pls help me on my problem in making my summary report on my data.

con 0001 A NA no
con 0001 B A YES
con 0003 A A yes
mat 0002 A A yes

I have data which DARtype-darno have their sub data which have their own revision and status, i am determining which one is latest by making a checkbox yes/no..

Refer to the example, Now i want to show in the report how many DARTYPE has been issued just like (CON 2 and MAT 1), and i want also to count each status of DarNo but it should count only the latest like (con status A is 2 and Mat status A is 1).. so it means the number of darno and and no of status will show should be tally

And 1 more thing, if i make a textbox and try to get the formula in report details.. it will make the result a multiple and duplicates but i will put in header it will make it 1 result but ignoring the other DAR type..

I hope you can help me guys.. i cannot find the answer in youtube.. this one is just like countif in excel..

Jomer is offline   Reply With Quote
Old 11-15-2016, 09:56 AM   #2
Uncle Gizmo
Nifty Access Guy
Uncle Gizmo's Avatar
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,519
Thanks: 591
Thanked 1,005 Times in 947 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Count and Summary multiple in reports

I found it very difficult to read your question. I don't know if I don't understand it or if it's just not intelligible. I think it's probably six of one and half a dozen of the other. Anyway I think you need an SQL statement with group by clause, and possibly a where clause. Try searching youtube for that. I would much rather you re-posted your question with a much better description before I make any further comment.
|                                     |
|      Uncle Gizmo              |
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote

count , report , summary

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a Record Count Summary JMM9000 Queries 7 08-07-2014 06:52 AM
Summary Count of Multiple Queries NavelRing Reports 5 11-16-2007 11:35 AM
Summary of Report - Count? DCount? SaraMegan Reports 6 09-07-2006 06:41 PM
Summary Count crescent-centre Reports 3 09-01-2005 06:02 AM
Summary count lines of VBA code camilovic General 1 05-28-2003 06:08 PM

All times are GMT -8. The time now is 08:49 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World