Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-02-2009, 03:08 PM   #1
F.E.A.R 2
Registered User
 
Join Date: Dec 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
F.E.A.R 2 is on a distinguished road
Exclamation Need HELP.. New To Access how to condence a report and making it a monthly report

Hey all,

ok basically what im trying to do here is when i generate a report i want to be able to have all of that data autopmatically comined in columes

this is what i have:
call attended did not attend

panama city 1 no yes
panama city 1 yes no
panama city 1 yes no
( so on and so on)
i want it to look like this!
call out.come shows
calls attened did not attend

panama city 123 43 97
jacobs town 412 231 120
Buffalo 344 213 111
(numbers dont add up but u get it)

how can i get all of these cities to add up in a report without having to add them up myself?

i basically want it to show the combined everything so that i dont have to spend 2 1/2 hours adding all of these up myself



and if you know how to make the report basically put in a monthly report that would be awesome!


Thanks for the help!!!!!!

F.E.A.R 2 is offline   Reply With Quote
Old 12-02-2009, 03:42 PM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,030
Thanks: 13
Thanked 4,063 Times in 3,998 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Need HELP.. New To Access how to condence a report and making it a monthly report

Try a totals query

SELECT call, Sum(attended) AS TotalOverall, Sum(IIf(AttendedField = True, Attended, 0)) AS TotalAttended, Sum(IIf(DidntAttendField = True, Attended, 0)) AS TotalDidNotAttend
FROM TableName
GROUP BY call
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 12-02-2009, 03:48 PM   #3
F.E.A.R 2
Registered User
 
Join Date: Dec 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
F.E.A.R 2 is on a distinguished road
Re: Need HELP.. New To Access how to condence a report and making it a monthly report

ok now where in the SQL qould i put that im more of a viral tech then a programmer just trying to take on a challenge

F.E.A.R 2 is offline   Reply With Quote
Old 12-02-2009, 03:55 PM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,030
Thanks: 13
Thanked 4,063 Times in 3,998 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Need HELP.. New To Access how to condence a report and making it a monthly report

That is (hopefully) a complete query, so copy it into the SQL window of a new query and see if it runs. You will obviously have to substitute the correct table and field names.

__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating An Executable (exe) Out Of Microsoft Access (mdb, mde) Tips and Tricks nIGHTmAYOR Modules & VBA 32 02-20-2012 04:27 PM
Making Query Criteria displayable on a report? (Access 2000) BlueChicken Reports 6 08-28-2009 12:50 PM
Beginner's Guide to ODBC Banana Access FAQs 1 06-18-2009 08:10 PM
access 97 printing of report is different than form mattsmusicpage Reports 0 10-07-2005 09:29 AM
Please help a Noob Ericnord General 5 06-08-2005 07:25 AM




All times are GMT -8. The time now is 01:12 AM.


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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World