Data types

[Guest]

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

 

[Guest]

Probably Value meaning numeric to 2 decimal places.

 

[Chaim]

Is this a Microsoft Access question?

 

[Al Camp]

Ernest,
I'm "guessing" Value? Are all the V2 fields numeric... perhaps with 2
decimal places?

I have a specification formatting sheet from someone.

I'd ask "someone"...

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

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

 

[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,

 

[Guest]

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.