I have a complex dilemna, for me at least.
I need to create a table based on a query i have created.
the Query has the following information
UserID ----- Ballots
1 --------- 1
2 --------- 2
3 --------- 1
4 --------- 3
5 --------- 1
from that query it would output this directly into a new table that is as follows
BallotID ---- UserID
1 ---------- 1
2 ---------- 2
3 ---------- 2
4 ---------- 3
5 ---------- 4
6 ---------- 4
7 ---------- 4
8 ---------- 1
I for the life of me can't even imagine how i'm ready to do this.
any help would be greatly appeciated.
I need to create a table based on a query i have created.
the Query has the following information
UserID ----- Ballots
1 --------- 1
2 --------- 2
3 --------- 1
4 --------- 3
5 --------- 1
from that query it would output this directly into a new table that is as follows
BallotID ---- UserID
1 ---------- 1
2 ---------- 2
3 ---------- 2
4 ---------- 3
5 ---------- 4
6 ---------- 4
7 ---------- 4
8 ---------- 1
I for the life of me can't even imagine how i'm ready to do this.
any help would be greatly appeciated.