Field Formatting

[tuktuk]

hey there........i have a table ("tbl_Final") who data is populated from an append qry.

one field is "RecodeType" where there are 2 type (Trans and Rev).

when the data is appended to the table ("tbl_Final") i am loosing the tens and thousand or cents of the dollars assciated wiht the Rev (revenue).

might i have hte fieid settign incorrect. does the properties on the append qry fields need to be set to something specific.

in short....the values of Trans should be whole (1,6,768,999, etc) and the values for rev should be (1.05,6.78,768.94,etc)

thanks
i know this is easier than i am makeing it.

T

 

[SydneyGeek]

The Trans field should be Number (Long Integer). The Rev field should be Currency.

Denis