RE: decimal not showing correctly in append query
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
The field type Long Integer means there are no decimal places even if you
specify some. Change the type to double
"naiveprogrammer" wrote:
> I have an append query that is not showing the cents in a number field. I
> have the field set to Long Integer, Currency & 2 decimal places. I.e. $14.35
> is round down to $14.00. $14.70 is rounding up $15.00. The table that I'm
> pulling the info from to append shows the correct amount.
>
> Any ideas?
.
Relevant Pages
- RE: import from excel to access
... in string format to a date, in the Update To row of the query: ... > I faced another problem in the append query part. ... > But how can i convert the field type back to 'Date/Time' in the append ... >> import serveral Excel files each month. ...
(microsoft.public.access.externaldata) - RE: import from excel to access
... I faced another problem in the append query part. ... But how can i convert the field type back to 'Date/Time' in the append ... > import serveral Excel files each month. ... Look at the validation rules and data rules in your Access table. ...
(microsoft.public.access.externaldata) - Re: Automatic Update Query?
... I would build an append query and put the following in ... open your table in design-view and change the field type to ... you will want to make sure that all future entries ... >> Rick B ...
(microsoft.public.access.queries) - RE: Type conversion in an append query
... Actually, it just occurred to me I don't want an append query, but an update ... In New table field type is Y/N. ... I get a conversion error and no data is transferred. ... > tia. ...
(microsoft.public.access.queries) - Re: 2006-07-26 00:00:00
... I haven't worked with OLE automation in Office in some time, ... you specify the field type in Word? ... It soulnd like it's looking for a ...
(comp.databases.ms-sqlserver) |
|
