Thanks! Worked like a charm.

GilaMonster (3/6/2009)

Sometimes, that is fortunate. I just figured it out - and it...

I read through that, and I'm hopeless. I am thinking that trade_date = 2 OR trade_date = 3 isn't being read correctly. For my purpose, I'm using 2...

I think that's beyond my skill level. But I do appreciate the help. I'll marinate on this problem for longer.

Thank you very much. That is what I was working for. But for some reason I can't get the results for when the trade date is on either...

Thanks, you have me on the correct track. However, I'm getting syntax errors. Am I using it wrong?

SELECTaccount_nbr, symbol, o_trade_nbr AS trade_nbr, o_record_type AS record, o_trade_date AS trade_date,...