Field Properties: Decimal Places - DOES NOT WORK!!!

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Richard (Richard_at_discussions.microsoft.com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 03:53:03 -0700

Hi,

I made a query. Some of the fields are Expressions; one of them:

SumOfFieldA / SumOfFieldB as FieldC

I need the expression result just as an integer, i.e. with no decimal
places. I changed in the Design View the properties of the field - Decimal
Places to "0".

However, I run the query, numbers in the fields are in full view (with 10-12
decimal places).

Can somebody help, please?

Thank you in advance.

Richard

Relevant Pages

  • Re: Parameter query from mulitiple fields
    ... "all expressions where there is a OTR error", ... I want to query one specific ... > error code and pull all the expressions for that code (but ... >>Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: Expression error when running report, but not in query.
    ... And both expressions calculate correctly on every record. ... Another weird thing is that the 1st report works correctly off it's query. ... > Calculated fields misinterpreted ...
    (microsoft.public.access.reports)
  • Re: Time Format and Calculation
    ... running the DateDiff function twice in every query record - as opposed to ... > Doug Steele, Microsoft Access MVP ... >> i have no idea why the expressions didn't work. ... >>> Reports. ...
    (microsoft.public.access.forms)
  • Re: Relational lattice completeness
    ... We are talking about expressions as described by the following syntax ... of D and a finite set of relation variables and f a function that maps ... Now we define two expressions e1 and e2 as query equivalent if they ... I am still not entirely sure what 'completeness' you have in mind. ...
    (comp.databases.theory)
  • Re: Expression error when running report, but not in query.
    ... table and using that as the record source for the report. ... > The parameters are at the beginning of the SQL. ... The query works when running from ... There are no null values in the fields for the expressions. ...
    (microsoft.public.access.reports)