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!