selecting records: "Or" won't work?

[jimwarren]

i am trying to select all records that have an "order status " of "D", OR have a hold_reason of "DECLINED"...

ie,

({sysoent.order_status} = "D&quot Or ({holdords.hold_reason} = "DECLINED&quot

the only records returned from the above are the hold_reason DECLINED ones.... the status "D" records are ignored...

separately they work as expected

is there another way to do this?

thanks! jim

 

[Ngolem]

try this instead

({sysoent.order_status} = "D" Or {holdords.hold_reason} = "DECLINED&quot

just one bracket around the whole expression


Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[lbass]

What is the relationship between the two tables and how are they linked?

-LB

 

[jimwarren]

the tables were the problem.... i guess i was trying too many different things at once last night...
i thought they worked separately, but once i added the holdords table, it broke the status D query....

i ended up making a separate report and inserting it as a subreport, and now all is fine!

thanks for the help.....