Recent content by hesykhia

Sorry plog, I didn't change it before because it was working and I didn't want to mess it up further. But I will do a bit more experimenting with it and apply your suggestion, unless I end up doing something completely different. I didn't realize it was bad form to double post in other forums...

Sorry, another question. I'm very new to access, and teaching myself as I go. I'm trying to manipulate SQL code into doing what I want without really understanding it completely, so I'm running into a lot of issues. Before you reply with "I don't understand why you're doing it this way, you...

Ah, I see. That makes more sense. Thanks, MarkK! That is an amazing resource, plog, so thank you so much for that! I will be using it a TON while I try to figure out SQL. I did find a way to make the report look like I wanted it to, through using a Union query. Here's a sample of the...

Thanks for the replies! When I put that SQL in, it asks for parameters for everything, which doesn't give me the info I need. I can't parameterize SHU Decision because I need to have each different situation (the 5 separate queries) end up on one big report, for the same date range. If I...

Please see my previous post here, to understand my current question a little more thoroughly: access-programmers.co.uk/forums/showthread.php?t=285364 I created 5 different queries with different outcomes of the same fields. I'm trying to make a report that includes all of these. I know I could...

And....after all that, I think I just figured it out. Sheesh. I changed the SHU Decision column to "Group by" instead of "Count", then added another "Date email received" column, selected "Count" on that one, and it's pulling back the right info. Well, thanks for being my sounding board, guys...

Unfortunately I can't attach the db because it has confidential information in it, but I have several different test entries with all varieties of criteria, so it should definitely be pulling something back. I can try to explain what is in those a little bit better. The date on all my...

I just started learning Access last week. I've built all my tables and forms, but the queries are majorly tripping me up, so any help you can give would be appreciated! I'm sure this has been asked a million different times, but I've been searching for hours and haven't been able to find an...