Search results

Thank you.. It works fine now! I couldn't get the count to work because I had too many group bys. Your SQL works fine for getting the count, but if I add the other fields needed on the report it corrupts the ability to get the count I needed. If I wasn't shown by a colleague how to use a...

Here is the SQL. I don'tknow how to post the actual query. I hope this will do. I need to count the number of [ERClient.Number] that falls under each [ERSubmitter.[Sbm Key]] within a date range. The date range parameters work fine. SELECT ERSubmitter.[Sbm Key], ERSubmitter.[Sbm Name]...

Counting rows in a Query I have an aggregate query that creates a report of "A" by "B". Each "A" can have many "B"s under it. The report works fine. I need to count and display on the report the number of "B"s for each "A". I can't seem to manipulate the "count" property of the query to...

I have a form whose data source is a select query, q3, that is built from 2 other select queries. I'll call them q1, q2, and q3. q1 is a parameter query where I enter a "Cutoff Date" that the 3 queries manipulte and generate the desired results that appear in the form. The problem is that I...

I open multiple DBs in VBA with a password. One of them gives error 3031 "Invalid Password" when the code runs. I can open it manually and disable the password so users can access it. But the next morning after the nightly updates it is the same thing. Thanks in advance for any help.