I recently converted an Access 2003 project to Access 2010. I noticed some differences in the report totals. I discovered that the filter was no longer working. This is my filter line "Recordtype = 'i'". I'm getting all records regardless of record type. Is this a known bug or am I doing something wrong?
Furher information. I added the phase & " and " & Report.Filter to my record source and it fixed the problem. However, I should need to do this and there are a lot of reports to fix.
Bob
Full Version: Filter Not Working For 2010 Reports
I dont know if RecordType is a reserved word, but often used in ADO.Recordset.
QUOTE (arnelgp @ Apr 2 2012, 02:37 PM) 
I dont know if RecordType is a reserved word, but often used in ADO.Recordset.
I looked it up. It is not. I believe this is a bug in Access 2010, of course I could be doing something wrong. However I'd like to report it to Microsoft. Can someone tell me what is the procedure?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.