Recent content by MonsterMike

I feel like a real dummy! This did the trick: SELECT Table1.Email_1 FROM Table1 UNION SELECT Table1.Email_2 FROM Table1 UNION SELECT Table1.Email_3 FROM Table1;

The wizard only appears to remove duplicate rows. I'm looking to remove duplicate records from the same row.

There are three columns (col_1, col_2, col_3) in one table that I would like to combine and remove duplicates. I am not getting the results I should be. My question is how would you do it? Do you see any errors? Here is what I've done (be warned, it's pretty ugly): SELECT [table].[col_1] FROM...

Thanks, that cleared it up for me!

Thanks for your reply, but I think I may have miscommunicated. Just to make sure I am receiving your communication as you intended it. Here is how I understand it: Option 1. Splitting Database via Database Splitter Wizard: This would create one back-end file with the tables, and one front-end...

Hello, This is my first post here so apologies if I violate any norms... My question: Which is better for multi-users: Splitting Database OR Linking to Data Source? I understand splitting the database into front-end and back-end could be the best way to allow multiple users to interact with...