I am designing a query it has about 20,000 records with 2 numerical fields(long integer).

I want to do a simple division i.e field3:Round([field1]/[field2],2)

It works so i assume i have no zero divisors. When i sort field3 Access returns an Overflow message.

I've herd this may be because my computer doesn't have the memory to perform the calc. Is there any other reason?

have you tried splitting this into two queries. One query for the calculation, then in the second query use the first query as the record source then sort.

cool bananas ill give it s hot when i get to work tomoz

what's the smallest value of field2?