+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Access - Calculated Fields in Technical; ...
  1. #1

    garethedmondson's Avatar
    Join Date
    Oct 2008
    Location
    Gowerton, Swansea
    Posts
    2,270
    Thank Post
    965
    Thanked 325 Times in 193 Posts
    Blog Entries
    11
    Rep Power
    165

    Access - Calculated Fields


    Does anyone know how to do calculated fields based on the results of a query?

    I have a car sales database . In the database we have created a multiple table query that displays which cars each sales person has sold.

    So if Sales Person 1 has sold 3 cars at £1500 + £2000 + £2532 then I need to add that up into a new field and display it on the report.

    I know how to add up different fields, but not how to add up the results of the query - which are all based in different records but the same field.

    Any help appreciated.

    Gareth

  2. #2

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    169
    You need to do a JOIN query on the salesman table and the sales table.

    You can get the total of the sales with

    SUM([sales].[sales value]) AS TotalValue

    Does that make sense?

  3. #3

    CESIL's Avatar
    Join Date
    Nov 2006
    Location
    Hampshire
    Posts
    1,404
    Thank Post
    109
    Thanked 267 Times in 198 Posts
    Rep Power
    169
    Actually I might have misunderstood what you are trying to do.

    You can get sub totals in reports by using grouping.

SHARE:
+ Post New Thread

Similar Threads

  1. MS Access help please
    By RabbieBurns in forum Office Software
    Replies: 2
    Last Post: 11th December 2008, 02:24 PM
  2. Replies: 1
    Last Post: 3rd October 2008, 11:36 AM
  3. SIMs.net - User defined fields in reports?
    By duncane in forum MIS Systems
    Replies: 4
    Last Post: 21st September 2008, 08:07 AM
  4. M$ Access
    By Hightower in forum How do you do....it?
    Replies: 5
    Last Post: 15th June 2008, 06:15 PM
  5. Quick letter fields not substituted
    By cjohnsonuk in forum MIS Systems
    Replies: 4
    Last Post: 20th March 2008, 01:42 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •