Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.