I am trying to set up a table on the fly but I don't know the field types. I
know how to do "create table test (name Text(10),length_1 number,paid
datetime)" I got errors when I tried to use "AutoNumber" and when I put a
size on "number(1,2)"

On Thu, 17 Feb 2005 06:57:03 -0800, "R Walker"
<(E-Mail Removed)> wrote:

>I am trying to set up a table on the fly but I don't know the field types. I
>know how to do "create table test (name Text(10),length_1 number,paid
>datetime)" I got errors when I tried to use "AutoNumber" and when I put a
>size on "number(1,2)"

try COUNTER
---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

Sorry, number is a wage with 2 decimals number(5,2)

"Andi Mayer" wrote:

> On Thu, 17 Feb 2005 06:57:03 -0800, "R Walker"
> <(E-Mail Removed)> wrote:
>
> >I am trying to set up a table on the fly but I don't know the field types. I
> >know how to do "create table test (name Text(10),length_1 number,paid
> >datetime)" I got errors when I tried to use "AutoNumber" and when I put a
> >size on "number(1,2)"
>
> try COUNTER
> ---
> If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
> MW
>

On Thu, 17 Feb 2005 08:57:02 -0800, "R Walker"
<(E-Mail Removed)> wrote:

>Sorry, number is a wage with 2 decimals number(5,2)
>
>"Andi Mayer" wrote:
>
>> On Thu, 17 Feb 2005 06:57:03 -0800, "R Walker"
>> <(E-Mail Removed)> wrote:
>>
>> >I am trying to set up a table on the fly but I don't know the field types. I
>> >know how to do "create table test (name Text(10),length_1 number,paid
>> >datetime)" I got errors when I tried to use "AutoNumber" and when I put a
>> >size on "number(1,2)"
>>
>> try COUNTER
>> ---
>> If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
>> MW
>>

I am a little confused:
do you have Access installed? if yes go to the help system and look
for: Microsoft Jet SQL reference, in Overview you have the comparision
of different Data Types and the Data Types from Access.

if you don't have it , tell me, I will post the two pages

I gues you are looking for currency: (Money) has 4 decimals

PS: I am working right now on a German system and I don't think this
help file will be much help for you
---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW