[AccessD] Weekend fun: Primes

On 9 Dec 2005 at 17:29, Josh McFarlane wrote:

> On 12/9/05, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
> > What's the largest number that can be stored as a long ( signed 32
> > bit)?
> 
> –2,147,483,648 to 2,147,483,647
> 
> Does Access support larger than long integer sizes?
> 

You can use "scaled integers": 

Currency 
- 8 bytes = -922,337,203,685,477.5808 to 922,337,203,685,477.5807
or
Decimal 
- 14 bytes =  +/-79,228,162,514,264,337,593,543,950,335 with no decimal point