Search results

Got it!! Its perfect. Thanks for all your help.

This DB is pretty old and I didn't start it. Your idea sounds great to me, but the powers that be want it to be JUST like it looked in Excel. :rolleyes: I've got my Select Queries doing exactly what I want. My question now is the Union Query. In my Select Queries, I have duplicates, and I...

Thanks Monkey. You've been a great help. I've almost got it. :D

ugh I don't understand what you mean by turn on grouping. Do you mean in the report? I also don't understand change the query to "Count" on "Start Date". I made 2 different queries: one for Issue and one for Jurisdiction. They both seem to show me what I want. I also played around with the...

But... ...I don't want to count only the Disciplines in "PERC", "DOAH", etc. I want to count all the Disciplines, period, no matter in which Jurisdiction they are in, but...I don't want to count any other Jurisdictions on my report. I want it to look like the attached. Here are my query...

vague There is data in both fields I've queried. I only want to show particular values in each field. Here's a pic of what I have. I want a report that counts how many records have those particular Issues and those particular Jurisdictions only. There are other Issues and Jurisdictions that...

I'm trying to make a report to display certain entries from 2 different columns in a table. In the query, I designate which criteria I want from each category, but on the report, it shows more than what I've asked for. I have an idea of what needs to happen, I just don't know how to do it.