C
Cheese
My friend and I have been keeping separate reference lists of our own, so I
would like to combine them to view the data side by side.
After appending the records into one table, I'm having difficulty with the
codes where [Station] is null, or does not have a perfect match with
[Station2], or vice versa. If it weren't for my friend having duplicates in
the
would like to combine them to view the data side by side.
After appending the records into one table, I'm having difficulty with the
codes where [Station] is null, or does not have a perfect match with
[Station2], or vice versa. If it weren't for my friend having duplicates in
the
Code:
field, I could do a simple update query.
Using the example below:
I would like the first two "ALC" records combined into one automatically,
since in reality they are identical, my friend just added some extra info in
the [Station2] field. Can I use some sort of "Like" criteria for an update
query (i.e. if [Station] is "Like" [Station2] then...)?
In case you're wondering, the last ALC record will have a null entry for
[Station].
[Code]-----[Station]--------------------------------[Station2] <---field names
|ALC|-----|Altamont, CA|-------------------------------- | null value |
|ALC|-----| null value |-------------------------------- |Altamont, CA (UP) |
|ALC|-----| null value |-------------------------------- |Alturas, CA (UP) |