R
Ranjit kurian
Hi
I have one Union Query which contain only customer Names, when i link this
query to Month Query and Current Query it should give me correct amounts of
that particular months...
Example:
Union Query:
Name
A
B
C
D
E
F
Month Query:
Name JAN FEB
A 5 10
B 6 20
C 7 30
Current Query:
Name April
D 1
D 2
E 3
F 4
F 5
I need a query, so that when i link the Month Query and Current Query with
Union Query the result should be as shown below
Combined Query:
Name JAN FEB April
A 5 10 0
B 6 20 0
C 7 30 0
D 0 0 3
E 0 0 3
F 0 0 9
I have one Union Query which contain only customer Names, when i link this
query to Month Query and Current Query it should give me correct amounts of
that particular months...
Example:
Union Query:
Name
A
B
C
D
E
F
Month Query:
Name JAN FEB
A 5 10
B 6 20
C 7 30
Current Query:
Name April
D 1
D 2
E 3
F 4
F 5
I need a query, so that when i link the Month Query and Current Query with
Union Query the result should be as shown below
Combined Query:
Name JAN FEB April
A 5 10 0
B 6 20 0
C 7 30 0
D 0 0 3
E 0 0 3
F 0 0 9