Re: Calculating values from an option group
From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 02/14/05
- Next message: Duane Hookom: "Re: If no records show criteria"
- Previous message: Adrian Brown: "Re: Print hidden report"
- In reply to: Proffy: "Calculating values from an option group"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Feb 2005 16:48:46 -0600
Try a text box with a control source like:
=Sum(Abs([Gender] = 1) )
This assumes your option group value is a 1 for either male or female. You
may need to edit this.
-- Duane Hookom MS Access MVP -- "Proffy" <Proffy@discussions.microsoft.com> wrote in message news:52C854C0-965C-4AE3-8E18-408D3A4CFE0E@microsoft.com... > Hi. I have a question. In my database I have an option group (gender) and > I > want to calculate the total for each of them separetedly, like 10 > students, 3 > males and 7 females, in my report. All I can get is the total for both > together. Appreciate your kindness.. > Odir
- Next message: Duane Hookom: "Re: If no records show criteria"
- Previous message: Adrian Brown: "Re: Print hidden report"
- In reply to: Proffy: "Calculating values from an option group"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
