Prev: How do I bring a filed from multiple records and join them togethe
Next: parent child link query
From: Dave on 16 Apr 2010 10:04
Gender fields is a value list - not pulling from a table.
All;Male;Female

I think it is not liking the "*"

If I remove the * and put in Female in the query criteria it gives me
correct answer

Thanks

Dave

"KARL DEWEY" <KARLDEWEY(a)discussions.microsoft.com> wrote in message
news:B69CBAEF-F2C2-4F72-9019-F3A23195A62D(a)microsoft.com...
> A couple of questions.
> What is the DataType of your Gender field? Post sample of data directly
> from the table.
>
> What is the source of data of your cboGender?
>
> --
> Build a little, test a little.
>
>
> "Dave" wrote:
>
>> Thanks to both of you but neither solution worked.
>>
>> Meaning they returned NO data.
>>
>> Any ideas?
>>
>> Thanks
>>
>> Dave
>>
>> "Dave" <dcooper(a)iacnc.edu> wrote in message
>> news:1AE66717-80B1-4A9B-88BE-452F68764242(a)microsoft.com...
>> > Access 2003:
>> >
>> > Trying to create a demographics report that will allow the following.
>> >
>> > Gender example
>> > On the form "frmStudentDemographics" is a drop down field named
>> > "cboGender"
>> > When the user makes a selection "Male" a report is generated for only
>> > Males.
>> > But in some cases the user will want to run a report for both (all)
>> > genders.
>> > So I added a check box next to the drop down named "ckAllGender"
>> > My idea is that if that box is checked then the report will show
>> > information on Both (all) genders.
>> >
>> > So in the query that generates the report, in the criteria for the
>> > Gender
>> > field I tried this:
>> >
>> > IIf([forms]![frmStudentDemographics]![ckAllGender]=True,"",
>> > [forms]![frmStudentDemographics]![cboGender])
>> >
>> > Note - I also tried: = 1, = yes
>> >
>> >
>> > My logic was that if there was nothing in the criteria ("") it would
>> > return all genders.
>> >
>> > Didn't work.
>> >
>> > Any suggestions on how to rewrite my criteria
>> > OR
>> > A different approach to this problem
>> >
>> > I am just using gender as an example as there will be several
>> > Demographic
>> > fields with drop downs and I want the user to be able to report on ONE
>> > or
>> > ALL for any of the fields.
>> > Hope I am making sense.
>> >
>> > Thanks
>> >
>> > Dave
>> >
>> >
>> >
>> > __________ Information from ESET NOD32 Antivirus, version of virus
>> > signature database 5029 (20100414) __________
>> >
>> > The message was checked by ESET NOD32 Antivirus.
>> >
>> > http://www.eset.com
>> >
>> >
>> >
>> >
>> > __________ Information from ESET NOD32 Antivirus, version of virus
>> > signature database 5030 (20100415) __________
>> >
>> > The message was checked by ESET NOD32 Antivirus.
>> >
>> > http://www.eset.com
>> >
>> >
>> >
>>
>> __________ Information from ESET NOD32 Antivirus, version of virus
>> signature database 5030 (20100415) __________
>>
>> The message was checked by ESET NOD32 Antivirus.
>>
>> http://www.eset.com
>>
>>
>>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5033 (20100416) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>

__________ Information from ESET NOD32 Antivirus, version of virus signature database 5033 (20100416) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



First  |  Prev  | 
Pages: 1 2
Prev: How do I bring a filed from multiple records and join them togethe
Next: parent child link query