R
Roger
I have merged data from three tables containing similar data into one using
a Union query. However, the data is not always identical and many fields
have no data:
tblOne
1 AAA CCC DDD
2 EEE FFF HHH
3 III JJJ KKK LLL
tblTwo
1 AAA BBB CCC DDD
2 EEE FFF GGG HHH
3 III KKK LLL
tblThree
1 AAA BBB CCC DDD
2 FFF HHH
3 III KKK LLL
The Union query has joined all the data together, but has regarded records
with one or more null fields as separate records (i.e. different to records
with populated fields). I need all the data from populated fields to be
returned, replacing the null fields where applicable.
Any ideas on how to do this. TIA.
Roger
a Union query. However, the data is not always identical and many fields
have no data:
tblOne
1 AAA CCC DDD
2 EEE FFF HHH
3 III JJJ KKK LLL
tblTwo
1 AAA BBB CCC DDD
2 EEE FFF GGG HHH
3 III KKK LLL
tblThree
1 AAA BBB CCC DDD
2 FFF HHH
3 III KKK LLL
The Union query has joined all the data together, but has regarded records
with one or more null fields as separate records (i.e. different to records
with populated fields). I need all the data from populated fields to be
returned, replacing the null fields where applicable.
Any ideas on how to do this. TIA.
Roger