By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

How to subtract 2 field in an Access Report?

yosiro
P: 34
How to subtract 2 field in report like the picture below? The Access just have some option like sum, average, min, max, etc, but not subtract.
Attached Images
File Type: jpg 1.jpg (16.1 KB, 186 views)
Oct 10 '12 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,316
It doesn't look like you're subtracting two fields but two rows. From the picture, it looks like for each Nama, there are two ids, 1 and 2. And your goal is to subtract id 2 from id 1. You can do this by grouping by nama, returning a negative for those that have id 2, and putting a subtotal on the grouping.
Oct 10 '12 #2

yosiro
P: 34
Yes you right, but how to return a negative for those that have id 2?
Oct 10 '12 #3

Rabbit
Expert Mod 10K+
P: 12,316
You can use the iif function for that.
Oct 10 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.