Quick question...
I have a table with 50,000 records in it. It was a linked table and one of the fields I needed to convert to numeric. So, I went ahead and put my "Val()" conversion formula in the necessary field. Initially I had made everything a "Group By" in the "total" field. I ran the query and I only received 48,000 records as the result. I took off the "Group By" and the query returned 50,000 records. I was under the impression the "Group By" did not consolidate records. I know this seems elementary, but never ran across something like this before.