Table field format

A

Amateur

I have an append query where all data is shown correct.
If I append this query to a table, one field is showing instead of 1.86 -
2.00. I've tried all possible configurations: I declared it as a number
field, decimals 2, format #,##0.00;(#,##0.00)[Red].
But it always shows 2.00 .
Can soemone help?
Klaus
 
K

Kathleen Anderson

Someone in the Access Queries newsgroup should be able to help:

http://www.microsoft.com/office/com...rosoft.public.access.queries&lang=en&cr=US--~ Kathleen AndersonMicrosoft MVP - FrontPageSpider Web Woman DesignsExpression Web Resources: http://www.spiderwebwoman.com/xweb/FrontPage Resources: http://www.spiderwebwoman.com/resources/Please reply to the newsgroup for the benefit of others"Amateur" <[email protected]> wrote in messagenews:[email protected]...>I have an append query where all data is shown correct.> If I append this query to a table, one field is showing instead of 1.86 -> 2.00. I've tried all possible configurations: I declared it as a number> field, decimals 2, format #,##0.00;(#,##0.00)[Red].> But it always shows 2.00 .> Can soemone help?> Klaus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format a table field 2
Access Macro Repeat Expression using value of a field in table 0
Formatting a query field 1
TABLE HELP 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Macro required for moving data between tables in specified format 10
Percentage in a form field used for formula calculation 2
Append Queries 1

Top