Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Pzoxic
-
Report run out of memory while generating
In my experience, this is a result of either too many records returned or, more commonly, too many records excluded. I am not sure if there is a specific list recordset size that will generate this error, it is more a combination of things. My solution has always been to go back and simplify the...- Pzoxic
- Post #2
- Forum: Microsoft: Access Other topics
-
Trim 2 most right symbols - IBM US --> IBM
Another way if you are specifically trimming a number of characters is: left(YourField,len(YourField)-3) This would trim the last 3 characters from the specified field.- Pzoxic
- Post #3
- Forum: Microsoft: Access Other topics
-
MS Access report save as Excel file
Actually, you can display it correctly using this format: =TEXT(012345678, "000000000") Or you can set your output to include a ' with the data.- Pzoxic
- Post #3
- Forum: Microsoft: Access Reports
