Recent content by AlecMA

Thanks, Bob. That may work. Here is the solution I got from another forum and it works. <A query-based way to solve it is craete another field in your table with the type you want, and then run this query : update <YOURTABLENAME> set <YOURNEWFIELD> = val(<YOURNUMBERASTEXTFIELD>) where...

Bob, Yes, I can use the query for pivoting, but the data type still going to be a "text"...

Hi! I have a problem to build Pivot table in Excel 2003. I’m creating this table base on the “External Data” which is a MS Access 2003 table. The table has 50 fields and about 500.000 records. (This is the reason, I can’t just export table to Excel and then do pivoting). One of the fields of...