Calculating several totals in one query

F

floyd33

I have a query issue I've been working on for some time. I need to calculate
Responses (Yes, NO, Pending for meeting attendance). This is easy enough.
However, then I need to calculate who actually showed up
(AttendeeType2=Speaker or Attendees). I have created two queries--one for
calculating the attendees and one for calculating who actually showed up. No
matter what I do, the totals do not come out correct. You will see
"qryAttendeeSummaryReport" is where I've tried to bring in the total for
those who actually showed up. This may not even be the correct approach.
Can anyone offer advice? is this even possible in one query?? Below are
links to the query I need to produce and another to the view behind it. Any
help is greatly appreciated.


Query View http://img.photobucket.com/albums/v354/floyd33/QueryMedThink.jpg

Design View
http://img.photobucket.com/albums/v354/floyd33/RecruitStatusQuery.jpg

Thanks so much!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Using Lookup Query with Calculated Value in Table ComboBox 2
Difference between 2 calculated fields showed as % of grand total 0
Rostering form: Adding New Lines to a table about a totals calculation. 4
Can't calculate Grand Total of several other expressions 1
Difference between 2 calculated fields showed as % of grand total 0
Adding a second employee to an event 2
Overtime Question Unlike Others (Pictures Included) 2

Top