Hi all, I am creating a database in ms access. I was needed to populate some reports. I was wondering if there was any difference in opening several recordsets as to joining them all under one recordset. I have used both approaches, but after I tried to upsize to sql I got several errors with my joins. I was wondering if there was any difference in either approach. Thanks for your time.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Should I use joins or can I just use multiple recordsets.
- Thread starter compucop
- Start date
Similar threads
- Locked
- Question
- Locked
- Question