Search results

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.