Results 1 to 5 of 5
  1. #1
    Vortex138 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Posts
    3

    Calculation/Comparison of Fields

    Please forgive my ignorance, I am a layman, at best, of Access. I am working in Access 2016, with essentially a dump table. The table contains all property data for the county I work in, and what I need to do is run a query where any property sold for less than 2x the Assessed value of the property. So, if a property is assessed at $100,000, the sales price must be between $100,000 and $199,000. I have both fields for Consideration and Sales Price in the table, so I need to create a new field in the query and calculate the difference between these two fields. Can anyone please assist me with formula that would be used, and how I could create that new field that doesn't exist in the table? I had Access training about 13 years ago, and haven't used it much since, other than to do simple queries, so a great deal of what I learned is lost...



    I thank you all in advance for any help you can give!

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    In the sales price field in the criteria row try >= Assessed And < [Sales Price]*2 - 1000
    You would have to modify the last part of the expression as I don't doubt it's not what you really want. Why would you not want 199,999??
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Vortex138 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Posts
    3
    Due to the request being "less than" the Assessed value. So, hmmmm, In this case, i can just leave out the "=" and make it less than. Thank you very much, I'll give this a shot!

  4. #4
    Vortex138 is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2020
    Posts
    3
    That worked perfectly! Thank you again!

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You're welcome. Wish they were all as easy
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Calculation across fields
    By maxyoyo in forum Access
    Replies: 3
    Last Post: 11-15-2014, 08:16 PM
  2. Trouble with Calculation Fields
    By DB88 in forum Access
    Replies: 7
    Last Post: 04-22-2014, 08:45 AM
  3. Calculation on two fields
    By braveali in forum Programming
    Replies: 8
    Last Post: 03-01-2012, 01:40 AM
  4. Same calculation on multiple fields
    By tko in forum Queries
    Replies: 4
    Last Post: 05-29-2011, 12:08 PM
  5. Replies: 1
    Last Post: 07-24-2010, 07:46 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
  •  
Other Forums: Microsoft Office Forums