Multiple Where Conditions

[Guest]

I can usually get a report to open with 1 where condition, with a bit of
fiddling. Is there a way that I can use multiple conditions to open a report?

Example. I want to open rptStudentAll with a boolean true associated with a
field called StudentWatch and the field Ethnicity with a code of 3.

How do I do that?

 

[John Spencer]

It is still one where condition, you just need to build it correctly.

StrWhere = "StudentWatch=True AND Ethnicity=3"

If you are trying to build that with controls, it would be something like

StrWhere = "StudentWatch = " & me.Checkbox & " AND " & "Ethnicity = " &
me.ComboboxEthnicity

As you can see from the above you need to include the " AND " or " OR " in
quote marks as you are building the where clause.

 

[Guest]

Thanks John. I never really encountered this before.
--

Rip

It is still one where condition, you just need to build it correctly.

StrWhere = "StudentWatch=True AND Ethnicity=3"

If you are trying to build that with controls, it would be something like

StrWhere = "StudentWatch = " & me.Checkbox & " AND " & "Ethnicity = " &
me.ComboboxEthnicity

As you can see from the above you need to include the " AND " or " OR " in
quote marks as you are building the where clause.