 |  |  |  |  |  |  |  |
Query in VBA does not pull same results as normal query
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Set rstDeps = CurrentDb.OpenRecordset("SELECT Members.OrgID, Members.ID, Members.Member, Members.PrimaryRep, Members.MembershipType " _
& "FROM Members " _
& "WHERE (Members.Member=True AND Members.OrgID=" & !OrgID & " AND Members.MembershipType='" & !MembershipType & "');")This is my query in VBA in MSAccess. I just want the number of people that fall into those criteria and it SHOULD be 4. But this consistently pulls 6 records. If I run this same query in a normal query it pulls 4.
The 6 records include 2 Members.Member=False. Why would it pull them as well? I'm fed up with this and don't understand why this does not work.
Last edited by tashakota; Aug 21st, 2007 at 12:00 pm.
|
Similar Threads
- sql query problem with MS Access and C# (C#)
- Clean Previous Next Script for MySQL results (PHP)
- test mysql query for no results (PHP)
- FILTER QUERY results on a FORM? (Visual Basic 4 / 5 / 6)
- Searches only returning results for certain strings (PHP)
- MySql multiple table query problem.... (MySQL)
- Querying within the results of a previous query? (MySQL)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: How to include multiple tables in FM format
- Next Thread: MS Access parameter querry criteria Help?
Views: 2861 | Replies: 2
| Thread Tools | Search this Thread |
Latest MS Access and FileMaker Pro Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS Access and FileMaker Pro
