report show info based on two query fields

[rdspollin]

i need a report to show info based on two seperate query fields. i currently
have the criteria for one of these fields set as "[Forms]![Frm: Report
Selector]![Customer]" however i need the [Customer] info on [Frm: Report
Selector] to search two seperate fields to see if the customer info is in
either field A OR B then and return report results appropriately. can this be
achieved?

 

[[MVP] S.Clark]

WHERE Field1 = [Forms]![Frm: ReportSelector]![Customer] OR
Field2 = [Forms]![Frm: ReportSelector]![Customer]

 

[rdspollin via AccessMonster.com]

thank you!

WHERE Field1 = [Forms]![Frm: ReportSelector]![Customer] OR
Field2 = [Forms]![Frm: ReportSelector]![Customer]

i need a report to show info based on two seperate query fields. i
currently

[quoted text clipped - 4 lines]

be
achieved?

 

[rdspollin via AccessMonster.com]

hmmm actually this doesnt work exactly how i want it to

this is my code

WHERE ((([Qry: Customer Query].[Customer Name])=[Forms]![Frm: Report Selector]
![Customer]) OR (([Qry: Main].[End Customer])=[Forms]![Frm: Report Selector]!
[Customer]) AND (([Qry: Main].[Engine Family])=[Forms]![Frm: Report Selector]!
[Family]) AND (([Qry: WIP Sub].[Included on Customer Satus Report])=-1) AND (
([Qry: Main].[keep on customer status report])=-1))

it seems to return various 'family' informaiton, almost as if it was isnoring
[Engine Family] / [Family]

thank you!

WHERE Field1 = [Forms]![Frm: ReportSelector]![Customer] OR
Field2 = [Forms]![Frm: ReportSelector]![Customer]

[quoted text clipped - 4 lines]

 

[rdspollin via AccessMonster.com]

ah!

just moved my OR to the end

like this

WHERE ((([Qry: Main].[Engine Family])=[Forms]![Frm: Report Selector]![Family])
AND (([Qry: WIP Sub].[Included on Customer Satus Report])=-1) AND (([Qry:
Main].[keep on customer status report])=-1) AND (([Qry: Customer Query].
[Customer Name])=[Forms]![Frm: Report Selector]![Customer])) OR ((([Qry: Main]
..[End Customer])=[Forms]![Frm: Report Selector]![Customer]))

sorted

hmmm actually this doesnt work exactly how i want it to

this is my code

WHERE ((([Qry: Customer Query].[Customer Name])=[Forms]![Frm: Report Selector]
![Customer]) OR (([Qry: Main].[End Customer])=[Forms]![Frm: Report Selector]!
[Customer]) AND (([Qry: Main].[Engine Family])=[Forms]![Frm: Report Selector]!
[Family]) AND (([Qry: WIP Sub].[Included on Customer Satus Report])=-1) AND (
([Qry: Main].[keep on customer status report])=-1))

it seems to return various 'family' informaiton, almost as if it was isnoring
[Engine Family] / [Family]

thank you!

[quoted text clipped - 3 lines]