Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-10-2016, 04:00 PM   #1
Jomer
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.

DARTYPE DARNO REV STATUS LATEST
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.
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      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
Reply

Tags
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
General
Tables
Queries
Forms
Reports
Macros
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