Search results

^ The goal is to feature a "Source" column that lists the other table(s) the record appears on. I was going to put in some sample data, but was having trouble recreating the problem (the actual file is pretty big with many tables and queries, so I wouldn't want to just post the whole thing)...

^No, (though I wish I could take advantage of IF statements, we're on an archaic system that uses "|" delimitters and Access doesn't seem to like those), it's just selecting the columns (and in my case I'm trying to concatenate them) The code looks like this: SELECT "First, " &...

Hi all, I'll try to come up with as simple an example as possible to illustrate what's going on. So let's say I have three tables: First, Second, and Third. The tables Second and Third each have a column with a default value of "X". I'm creating a query that selects fields from First...

Thanks to both of you, AUGuy and bijuvijayaraj!

Thanks for your help! I do think, though, that might be a little too advanced for me at the moment. What I was thinking of doing was creating a relationship between the two tables and have the corresponding fields be the primary/foreign key and then enforcing referential integrity. Do you...

Kind of an Access newbie here, so bear with me, but I have two tables: a master list of data and another that shares many of the same fields but the data is updated/replaced every so often. Let's say they both share a "Member ID" field. Can I make a validation rule on this field so that you...