Double versus Text - Access Query Performance

[Aurillius]

Hi,
I have created a unique number for my MS Access 2007 table. This number takes 3 of the existing fields and concatenates them together. The DB has a temporary import table which will only add records to the main table if the unique number doesn't exist in the master table.

What I would like to know is that would it increase performance to store this field as a DOUBLE or should I keep it as TEXT.

An example of this number would be:
0000131003111
(13 digits)
Thanks,
Mark

 

[dhookom]

I wouldn't think it would make a significant difference as long as the field is indexed.

Duane
Hook'D on Access
MS Access MVP

 

[Andrzejek]

Also, if you talking Double, you would get 131003111 (no leading zeros) instead of "0000131003111" as Text

Have fun.

---- Andy

 

[TheAceMan1]

How are ya Aurillius . . .

If you want to maintain the leading zero's then your stuck with [blue]text[/blue]. Otherwise indexing the field is paramount (already stated by [blue]dhookom[/blue]).

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]