Calculated fields in query

From: Christopher (anonymous_at_discussions.microsoft.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 03:34:16 -0700

Hi

I am stuck here and need some help with this one.
I have a select query which I need to calculate the
following operation:

The first field:
[DaysAllowance]
GroupBy

The second field:
[Days Taken]
Sum

For The third field:
[DaysAllowance]-[Days Taken]
Expression (does not seem to like another Sum)?
The query returns the value 20 whereas it should return 0,
as the first field value is 20 and the second field is
also 20.
I really am scratching my head with this one.
Thanks for your help.
Chrisopher

Relevant Pages

  • Re: Design View Criteria question
    ... The first query will use AND logic: it will return those records for which the ... first field is equal to 123 (regardless of the value in the second field), ...
    (microsoft.public.access.queries)
  • Re: Group by (Selecting First) after Sorting
    ... You posted in the tablesdbdesign newsgroup. ... If you want a query that sorts by the first field, ... ascending order on the second field, which gives, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: IIf comparison
    ... How would I link this query to the report? ... > Qreate a query with the following equation ... >> where if the first field is greater in value than the second field, ... But if the first field is less in value ...
    (microsoft.public.access.reports)
  • Re: Ascending Sort Problem
    ... Create a query. ... In the first field put the following expression: ... In the second field, put this expression: ... In the third field, put this expression: ...
    (microsoft.public.access.queries)
  • Using the result of a calculated field in another calculated fields expression
    ... I am stuck on something that seems fairly straightforward but haven't ... The second field has a calculation based on the first field. ...
    (microsoft.public.access.queries)