Hi, Joe. If I understand your problem correctly, I think you may need a UNION query.
Something similar to that below: SELECT Col1, Col2 FROM Table1 UNION SELECT Col1, Col2 FROM Table2 This assumes Col1 is a compatible data type in both Table1 and Table2, as is Col2. This will give you the entire set of data from both tables in one view; that is if each table contains 10 records, the view will consist of 20 records. Cheers, Jim. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
