query to sum codes

From: joe (joe_at_discussions.microsoft.com)
Date: 08/13/04 

Date: Thu, 12 Aug 2004 17:03:01 -0700

Hello,

I have a table which has one field containing three letter codes that stand
for a credit amount.I want to create a select query that would identify some
code from others.These codes are text but i am confused how to obtain
separate totals to stand for the sum of two columns...for example....sum
=credit given and the other would be something like sum =denied
credit.Should i go back to the tbl design and input an identifier such as a
number like (RSD1) for some codes.Would the query select it and sum it
according to identifier??Please help....

Relevant Pages

  • Calculating fields for Access
    ... Save that query, and now use that the basis of your SUM ... >I am trying to SUM the pay codes based on hours. ... >There is no problem when I execute the queries ...
    (microsoft.public.access.gettingstarted)
  • Re: whats wrong with my query
    ... filter out the specific codes listed. ... and don't sum totals). ... However I have split the query into two queries one to filter the procedure ...
    (microsoft.public.access.queries)
  • Calculating fields for Access
    ... I am trying to SUM the pay codes based on hours. ... If I run the query I receive the total ... There is no problem when I execute the queries ...
    (microsoft.public.access.gettingstarted)
  • Calculatons in SUM
    ... I have 5 fields in a query. ... I am trying to SUM up all codes by hour. ...
    (microsoft.public.access.queries)
  • Re: True crime hits home?
    ... Yesterday we discovered my husband's credit/debit card numbers were used ... to purchase eight copies of WindowsXP direct from Microsoft. ... If we get a ding on our credit ... the disks sent to our address but the key codes emailed to him. ...
    (alt.true-crime)