Results 1 to 8 of 8
  1. #1
    ttitto is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Apr 2010
    Posts
    5

    Question using the total of a column in a query for calculating other column of the same query

    I have a problem building my apiary database. I would like in the last field of the query to have divided the maxofstrength value for each row by the total average for the MaxOfStrength column. How can I achieve this?



    Thank you in advance for replying!

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    well this is confusing. but the way i read it, this update will give u what it is u want

  3. #3
    ttitto is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Apr 2010
    Posts
    5
    Thank you for the answer! But it is not what I need. I attach a picture with what I want to achieve because I can not explain better.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    sorry bud, the picture is unreadable. post something that's legible

  5. #5
    ttitto is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Apr 2010
    Posts
    5
    Here is bigger picture, I hope this time is OK!

  6. #6
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    this works:
    Code:
    SELECT DISTINCT opening.[bee family], 

    dmax("strenght","opening","[bee family] = '" & [bee family] & "'") AS maxOfStrength

    maxOfStrength/davg("maxOfStrength""[strenght query]") as AverageField

    FROM opening


  7. #7
    ttitto is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Apr 2010
    Posts
    5
    My Access crashes with this code pasted in SQL view of the query. Here is information about the crash:

    Problem signature:
    Problem Event Name: APPCRASH
    Application Name: MSACCESS.EXE
    Application Version: 14.0.4750.1000
    Application Timestamp: 4b8bade7
    Fault Module Name: ntdll.dll
    Fault Module Version: 6.1.7600.20548
    Fault Module Timestamp: 4ad6bcd5
    Exception Code: c0000005
    Exception Offset: 00022262
    OS Version: 6.1.7600.2.0.0.256.1
    Locale ID: 1026
    Additional Information 1: 942d
    Additional Information 2: 942dba41db5cc49b6520588fc7dd628e
    Additional Information 3: 8faf
    Additional Information 4: 8fafa37544fe7f038b651375e9d26b5b

    Read our privacy statement online:
    http://go.microsoft.com/fwlink/?link...8&clcid=0x0409

    If the online privacy statement is not available, please read our privacy statement offline:
    C:\Windows\system32\en-US\erofflps.txt

  8. #8
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    well i can't offer services to fix that sir. all i can offer is to take a look at it for you and guarantee that it works for me. if you have serious problems with the database, i suggest you pay to get it fixed

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-15-2010, 02:07 AM
  2. Empty Column in Query
    By sesproul in forum Queries
    Replies: 3
    Last Post: 01-18-2010, 06:04 PM
  3. Calculating the column value
    By access in forum Queries
    Replies: 6
    Last Post: 08-20-2009, 11:51 AM
  4. inserting values in column based another column
    By wasim_sono in forum Database Design
    Replies: 1
    Last Post: 06-27-2006, 05:23 AM
  5. 2 different fields into 1 column by query?
    By rainxking in forum Queries
    Replies: 1
    Last Post: 06-04-2006, 09:37 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums