I want to Add Multiple Criteria in an Access Report

[Julio1974]

I have a database where I have a field (Disposition) that allows you to choose options from a drop down menu, and I want to count each of those options in a Report. How can I do this?

I've tried the following:

=SUM(IIF([Disposition] like "Partial Grant", 1, 0))

=Count(IIF([Disposition] like "Partial Grant", 0))

I keep getting a large number. I think it's because it's double counting the some of the Disposition Results. Please help?

-Julio

[zmbd]

Julio1974 , Welcome to Bytes!

This would be something best handled in an aggregate or cross-tab query. And then there is the crosstab query that should be able to handle the same thing. In this case you're preference.

You should post your entire SQL - Please format it using the code button and you should read the posting guidlines as to how to post the SQL.

You might consider reading thru Aggregate Query Woes as some of the pitfalls are pointed out here.

Here's Mr. Brown's site... a ton of tips so I'd bookmark this site! However, in this case the cross-tab: Crosstab query techniques

Some basic SQL stuff - : Queries in Access using SQL View

Another mention of the cross-tab; however, this will help with some with the report side: Dynamic Reports

That should be enough to get you started. Rabbit, Neopa, and/or others should be along shortly (if they haven't already posted while I was typing this ... they type faster than I do :-P )

Once you get your query/report put together, should you still be having issues, please read the FAQ and posting guidelines about how to post your SQL/Code and will take another poke at the problem.

[Julio1974]

Zmbd, thanks for the quick response! As you can tell, I'm not a programmer. I'm just attempting to take on the challenge of automating a report I have to submit annually, and it has a lot of basic summation, as well as other more complicated stats (median's, averages, etc).

I'll read through your suggested sites.

Thanks again,
Julio

[NeoPa]

Julio, your first attempt seems fine to me. There is little point in using the Like operator when = will do just as well, but this won't actually cause any problems.

If the results are not as expected then you need to look at what you are expecting and why. Unfortunately, with the limited info available to us, there's little we can help with on that score.