Recent content by biobee

Hi, You see the error message because one of the following reasons: 1. One or more of your columns doesnot have the right format property ie. the column has a mix of text and numeric or something else 2. The SQL statement that you have created (go to SQL view in query mode) is not complete and...

Hi Jon K, Thanks a lot for sharing this VBA code. I was looking for exactly something like this for a similar problem of collapsing multiple rows to a single row. I need a little help though. After running the VBA code on my query I get the collapsed rows, however for many rows the values are...