I found one other similar topic but it did not help and still remains unsolved. I also apologize that i had to submit this from my phone but here we go.
The Scenario: i have three columns labeled DonationValue, NetDonation, and PickupRequired. Both donations are text based and pickup is a yes/no checkbox. I know i must edit this information in the field box in design view for the query. I know this as the query it was required that i copy it from has NetDonation: [DonationValue]-8.75 as its field value.
The Request: It has been asked that if the checkbox is marked true I need to take the amount thats in DonationValues and subtract 8.75 from it to create new NetDonation. At the same time if the box is false NetDonations = to DonationValue.
I am stumped. We just learned about crosstabs and IsNull but i fail to see where that would help here. We learned about the build tab a chapter ago but i dont know where to begin. If you need clarification please ask. Again, posting from my phone and i apologize.