Joins??

[kbreiss]

I have two tables...1.) Expense, 2.)Income
How would I get a result set to give back everything in expense and everything in income. Seems easy, but I'm stumped.

Thanks in advance,
Kacy
________
Ford iosis

 

[Pat Hartman]

I would have used a single table with a transaction type rather than separate tables. You can obtain a single list by creating a Union query but the union query willl not be updatable so it is more useful as the recordsource for a report than a form.