Hello, everyone! I hope you and your families are all healthy.
May I please ask an Access question? Thank you.
I have two Access databases containing data I imported from Excel spreadsheets.
The first contains my entire music collection. The second contains the music I have in my car. (See the attached .zip file.)
I was hoping there is a way to link or bind these two databases together, and have Access compare them, then generate a report (or table) that displays all the records that are not in the CAR database.
Please allow me to elaborate. Here's an example:
I have ten Steely Dan albums in my Master collection database:
- Aja
- Alive in America
- Can't Buy a Thrill
- Countdown to Ecstasy
- Everything Must Go
- Gaucho
- Katy Lied
- Pretzel Logic
- Royal Scam
- Two Against Nature
In my Car database, I have four Steely Dan albums:
- Aja
- Everything Must Go
- Pretzel Logic
- Two Against Nature
I'd like Access to compare the records, and generate a report or table that shows this:
- Alive in America
- Can't Buy a Thrill
- Countdown to Ecstasy
- Gaucho
- Katy Lied
- Royal Scam
Actually, of course, I'd want the artist's name along with the album title.
I want this done for the entire database, not just one artist. I hope this makes sense.
Is this possible? If so, is it easy? Difficult? Will I tear my hair out trying to figure out how to do it? I'm not really much of a db designer or expert, but I'm willing to give this a go if it can be done.
Thank you! T. Hulot
PS: I am using Office 365 on Windows 10