S
sverre
Hi
I have built a union query (still not complete with all 40 queries but 3 are
built and shown below) that looks like this:
SELECT * FROM [ÄÄ Saldo 2741 summerad]
UNION
SELECT * FROM [ÄÄ Saldo 2751 endast nollkupongare summerad]
UNION
SELECT * FROM [ÄÄ Saldo 2751 exkl nollkupongare summerad];
The second and third query above should if possible be shown on same row,
"summed" (fields to be summed are named "SESAM"; HB. The last field
"account" is only for information and is for these queries the same number,
"2751" and should NOT be summed)
Secondly it this not is possible then I would like to add a comment-field to
be shown with the value "Zerobond" and "nonzerobond" for respective 2 queries
above.
Many thanks in advance,
Sverre
I have built a union query (still not complete with all 40 queries but 3 are
built and shown below) that looks like this:
SELECT * FROM [ÄÄ Saldo 2741 summerad]
UNION
SELECT * FROM [ÄÄ Saldo 2751 endast nollkupongare summerad]
UNION
SELECT * FROM [ÄÄ Saldo 2751 exkl nollkupongare summerad];
The second and third query above should if possible be shown on same row,
"summed" (fields to be summed are named "SESAM"; HB. The last field
"account" is only for information and is for these queries the same number,
"2751" and should NOT be summed)
Secondly it this not is possible then I would like to add a comment-field to
be shown with the value "Zerobond" and "nonzerobond" for respective 2 queries
above.
Many thanks in advance,
Sverre