The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)
The start...
I want to set the subreport record source with a pt query. I have to set it in VBA for the main report because I'm passing parameters so I went ahead...
Okay, correction. The problem is in my SQL. The issue is the reference to Reports!WeeklyApplicationR!OperationsID in the master report. I just ran it...
Okay yes, I see what you're saying. I thought that's what I was doing in my original code. It was working fine until I tried to make it a Pass Thru....
Minty, not 100% clear but that's through no fault of yours. I need to just sit down and learn the finer points of MSSQL and how to best use them with...
Reason for instability possibly because Null cannot be compared to anything else because there is nothing to compare. However, expression of Null >=0...
