Okay, there's probably an easy solution to this, but I can't seem to find it.
I have a table called "Donations". I need to query field DonationValue twice (sum and avg), and DonationID (for # of donations). When I put the caption in the property sheet, it won't let me use two different captions for DonationValue.
Unfortunately, SQL is beyond my abilities right now.
What I have is a Donations table with the following fields: DonationID (pk), DonorID (fk), AgencyID (fk), DonationDate, Description, DonationValue.
I need to make a query showing "Total Donations", "Average Donation" and "Number of Donations" as the captions. I am using DonationValue for the total and average columns, and DonationId for the number of donations. I can't seem to name the first two fields two different caption names, while the last one I can give it it's own caption.