Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Representation. 1
- Thread starter turborob
- Start date
-
1
- #2
They are all different
Main one's most all have
Type Description
-------------------------------------------
String or Text Can have any characters and numbers
Numeric Only Numbers digits (best for currency and math formulas)
Date Format varies 03/02/01 20010302 (best when you need to calculate dates like 30 days back, or..)
Memo Can hold Large amounts of non-searchable text or numbers
Each type above usually has sub types Numerci can be Integer, (no decimal places), Long Integer, Single (decimals), Double, Currency, etc.
Each number type takes up less space that the next.
The fastest search or to find an item in your database is Numeric. Numbers usually only take a few bytes to hold a large number.
Remember in the old days the computers could not find anything unless you knew its NUMBER. That why they used a number cause it was very fast to find. DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
Main one's most all have
Type Description
-------------------------------------------
String or Text Can have any characters and numbers
Numeric Only Numbers digits (best for currency and math formulas)
Date Format varies 03/02/01 20010302 (best when you need to calculate dates like 30 days back, or..)
Memo Can hold Large amounts of non-searchable text or numbers
Each type above usually has sub types Numerci can be Integer, (no decimal places), Long Integer, Single (decimals), Double, Currency, etc.
Each number type takes up less space that the next.
The fastest search or to find an item in your database is Numeric. Numbers usually only take a few bytes to hold a large number.
Remember in the old days the computers could not find anything unless you knew its NUMBER. That why they used a number cause it was very fast to find. DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question