I have a report with several sub reports and I almost have the data the way I want but I can't get the last little tweak. It was working until two dif Sales Rep could have the same Company. With Company as a subrpt and Date & wage as a nested sub rpt within the Company sub the duplicates still show. I have Hide Duplicates set to yes. I even recreated the subreport. I tried unnesting but then the data doesn't stay with the Sales Rep. I've attached an Excel spreadsheet that hopefully makes this more understandable and shows what I want.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Sometimes MS breaks things just for fun...
In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset.
Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters.
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…