Thanks for your reply. I'm only using it for Crystal to design the report. I just didn't like having two separate SQL statements to keep in sync;