Overflow!

[pickslides]

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?

 

[Dennisk]

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.

 

[pickslides]

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

 

[Darth Vodka]

what's the smallest value of field2?