+ Reply to Thread
Results 1 to 4 of 4

ACCESS query equations

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    excel 2010

    ACCESS query equations

    I have a database that contains species, height and diameter for 1000's of trees. I need to create a query that calculates the volume of each tree using a different and complicated equation for each species. (there are approximately 8 different equations to use) I though about writing a complicated if/then statement but that has proven too burdensome. I'm sure I could do this with a of lookup table or script but I don't know where to start.

    Thanks in advance for your help

  2. #2
    Administrator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit

    Re: ACCESS query equations

    Suppose you give us the layout of your table. The expression that you wish to calculate and let us see if we can help. Without this minimum of information, there is not much we can offer you. Try to be as specific as possible. It is possible there may be a Query Solution and at least a VBA solution. The devil is in the details.

    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365

    Re: ACCESS query equations

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you


  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    MS-Off Ver
    office 97 ,2007

    Re: ACCESS query equations

    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Importing Access query into Excel:Microsoft Query
    By ge0rge in forum Excel General
    Replies: 3
    Last Post: 04-02-2009, 10:51 AM
  2. Can I use MS Query in Excel like an Append Query in Access
    By Sam Wardill in forum Excel General
    Replies: 0
    Last Post: 04-11-2006, 09:45 AM
  3. Replies: 0
    Last Post: 03-19-2006, 08:50 PM
  4. Database Query-a query that reads data from MS Access
    By Osmar Mateus in forum Excel General
    Replies: 4
    Last Post: 01-29-2006, 04:10 PM
  5. [SOLVED] Run Access query from Excel, input value to query being value in c
    By Nagesh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2005, 10:10 AM


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1