Search results
-
D
Same SQL statement but different results via VBA Query
Aha! You may not believe this, but I changed the report version so that it uses "1" instead of "True" in the Where clause. It now works!- dysert
- Post #27
- Forum: Modules & VBA
-
D
Same SQL statement but different results via VBA Query
Hi, and thanks for replying. Here is the SQL from the report: SELECT DISTINCT LB.[Missed Check], LB.[Bill Vision], LB.[Bill Medical], LB.[Bill Dental], LB.[Leave Code], LB.[Bill Date], LB.SSN, LB.[Line Total], LB.[Due Date], LB.[Bill Amount], SBT.[Payroll Start] AS PayrollStart, SBT.[Payroll...- dysert
- Post #26
- Forum: Modules & VBA
-
D
Same SQL statement but different results via VBA Query
Is anyone still watching this thread? I hope so because I have a similar problem to the OP. I'm running Access 2013 under Windows 7. (And I'm an Access novice.) When I run a report I get a wildly different result set versus using the same SQL in VBA. Can someone please help me figure out what's...- dysert
- Post #24
- Forum: Modules & VBA