Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

ok, tricky one:

i need to merge one field in an access 2007 database and merge it into one filed in a query. hard part: i need to keep the data that goes with the new records.


col1 |col2 |col3 |data1 |data2 |
1    |     |8    |90    |true  |
     |     |     |40    |false |
2    |     |     |90    |true  |
8    |4    |10   |100   |false |


1  |90   |true |
8  |90   |true |
2  |40   |true |
8  |100  |false|
4  |100  |false|
10 |100  |false|
share|improve this question
up vote 1 down vote accepted

Create three separate but very similar append queries. With criteria in col1, col2 or col3 being "not is null".

share|improve this answer
i have 7 fields like the col fields... is there any way to make this faster to do? – crazybmanp Dec 1 '09 at 21:48
Yes, if you were generating the queries in VBA code but otherwise no. Besides once you have the first query done the subsequent queries should only take a few seconds to copy and change – Tony Toews Dec 2 '09 at 1:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.