large number, store and sort

From: AHopper (anonymous_at_discussions.microsoft.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 11:38:55 -0700

Two types of numbers.
First type:
I have a 20 digit number that will be scanned into the
database and it can store with or without spaces (I am
presently planning to store it without spaces). The
number will not be used for math purposes but will need
to be sorted on the first seven of the last eight digits
(see below)

Example:
             7780 1474 3470 0227 3664
Needs to be sorted on 0227 366

Sorting on these numbers will put the whole number in the
right sequence (ascending or descending) for reports etc.

What field type would be best to use - text, number etc.?

If number is the right choice, what field size - Long
Integer, Single, Double etc.?

How would I set up to sort (first seven of last eight
digits)?

Second Type:
                C 108900 P 00516338
This number can be scanned and stored with or without
spaces.

I would like to store only digits greater than 0 from the
00516338, in this case 516338. (Let me know if this is a
question for Forms, Forms programming since I think it
will need to be set up in one of the events of the text
box when the entry is made.

What field type would be best to use?

If number is the right choice, what field size - Long
Integer, Single, Double etc.?

How would I store only digits greater than 0 from the
last eight digits?

Thank you in advance for your help.

Allan

Relevant Pages

  • Re: bigint queston C++ classes
    ... I suggest an array of unsigned char, or unsigned short, or perhaps unsigned ... You'll need ceil/log) base-b digits to store x, ... these are not strings, ...
    (comp.programming)
  • Re: bigint queston C++ classes
    ... I suggest an array of unsigned char, or unsigned short, or perhaps unsigned ... routine for turning the end result into base ten for display, ... You'll need ceil/log) base-b digits to store x, ...
    (comp.programming)
  • Re: encryption with python
    ... >> and a birth date (8 digits, could be padded to be 9) and obtain a new ... they will be kept in a database anyways. ... > generating the same IDs over and over again. ... numbers in a random order) I'd not only store the number in the ...
    (comp.lang.python)
  • Re: Big numbers
    ... My problem is how to store it in C. ... It's not important that it comes from a database. ... close to keep the last three digits accurate. ... It is extremely unlikely that your data base query returns it's ...
    (comp.lang.c)
  • Re: Parse current IP address into environment variables
    ... environment variable called Store based on its value, ... running your script. ... on the MAC address rather than the last two digits of the last octet of the ...
    (microsoft.public.scripting.vbscript)