Data types

E

Ernest Lai

I have a specification formatting sheet from someone

T = Text
D6 is some sort of date format
what does V2 = ?

V2 is currently the data type for Labour, VAT , Total value etc...

Thanks in advance

Ernest Lai
 
E

Ernest Lai

yes its an access question. And yes they are all numerical values. I am
just wondering if V2 specified numeric value like "number, double" or
"number, long integer" etc.

Reason I ask this:

I have an output from my program which I have arranged now ready for export
into a text file. However the numbers in these numeric values have a lot of
"000" before them and these zeros dont show up at the moment.

EG. 00000100 will show up as 100

So I am thinking it has something to do with the V2 data type.

Ernest Lai
 
G

George Nicholson

You'll probably get your best answer by asking whoever created the
"specification" sheet (or checking the Help file of whatever software
created it). AFAIK, there is no "universal standard" shorthand for these
things, and even if there were, there is no guarantee those standards were
followed.

In other words: your guess is as good as ours...<g>

HTH,
 
E

Ernest Lai

Yeah George I have tried, but for some reason they have no real urgency to
read my emails. I'm sure ill find out sooner or later. Just hoped it might
be a universal thing. :)
 
Top