Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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.

example:

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

output

out|data1|data2|
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .