Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2013

    Unanswered: Captions In Queries

    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.

    Thank you for helping me with a noob problem.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Not sure to understand but, in the query, did you try to use aliases:
    SELECT ... SUM(DonationValue) As SumDonationValue, AVG(DonationValue) As AverageDonationValue , ...
    FROM ..., etc.
    Have a nice day!

  3. #3
    Join Date
    Nov 2013
    Thank you, Sinndho!

    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.

    Any ideas?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts