David Ball
Registered User.
- Local time
- Today, 09:29
- Joined
- Aug 9, 2010
- Messages
- 230
Hi,
I have a report that I am trying to filter with VBA code.
After running the code I get the following in the Property Sheet, Data, Filter row:
[Project] IN('KLE323 Piperacks EC Project') AND [Reporting Week Ending] IN(#2/06/2017#)
The report is not working and always stays blank with no records. If I manually modify the string to just [Project] IN('KLE323 Piperacks EC Project') the report opens correctly. If I manually adjust it to just [Reporting Week Ending] IN(#2/06/2017#) the report also opens correctly.
I have double checked that there are records that meet both these criteria.
Is there something wrong with the way I am expressing the "AND"?
Thanks very much
Dave
I have a report that I am trying to filter with VBA code.
After running the code I get the following in the Property Sheet, Data, Filter row:
[Project] IN('KLE323 Piperacks EC Project') AND [Reporting Week Ending] IN(#2/06/2017#)
The report is not working and always stays blank with no records. If I manually modify the string to just [Project] IN('KLE323 Piperacks EC Project') the report opens correctly. If I manually adjust it to just [Reporting Week Ending] IN(#2/06/2017#) the report also opens correctly.
I have double checked that there are records that meet both these criteria.
Is there something wrong with the way I am expressing the "AND"?
Thanks very much
Dave