report show info based on two query fields

R

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?
 
M

[MVP] S.Clark

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

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]
Click to expand...
[quoted text clipped - 4 lines]
Click to expand...
 
R

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! :)
Click to expand...
[quoted text clipped - 3 lines]
Click to expand...
 
Top