<div>
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave the following recommendation for this question in the Cleanup topic area:<br />
<br />
Accept: Arthur_Wood {<a href="http:#9733717" rel="ugc">http:#9733717</a>}<br />
<br />
Please leave any comments here within the next seven days.<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
stevbe<br />
EE Cleanup Volunteer
</div>


No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: Arthur_Wood {http:#9733717 [http:#9733717]}

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

stevbe
EE Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
I want to subtract, add, multiply, and divide different records in my Access query....How do I do this? &nbsp;For example:<br />
<br />
Select Dog, Cat, Beaver<br />
From Animals<br />
<br />
I want to divide Dog into Cat, and subtract Beaver from Dog.<br />
<br />
<br />
I would like to apologize for my example and appreciate your help with this nonetheless.<br />
<br />
cheers.<br />
<br />
pr
</div>
</div>


I want to subtract, add, multiply, and divide different records in my Access query....How do I do this?  For example:

Select Dog, Cat, Beaver
From Animals

I want to divide Dog into Cat, and subtract Beaver from Dog.


I would like to apologize for my example and appreciate your help with this nonetheless.

cheers.

pr

MS Access Math in Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.