I have 3 queries - how would I combine them to all report in 1 query?
Code:
SELECT Count([Wires_I-incoming_O-outgoing].[Transaction Amount]) AS NumOfTrans, Sum([Wires_I-incoming_O-outgoing].[Transaction Amount]) AS Total
FROM [Wires_I-incoming_O-outgoing];
Code:
SELECT COUNT([Wires_I-incoming_O-outgoing].[Transaction Amount]) AS Unique_Orig1
FROM [Wires_I-incoming_O-outgoing]
WHERE ([Wires_I-incoming_O-outgoing].Direction="O");
Code:
SELECT COUNT([Wires_I-incoming_O-outgoing].[Transaction Amount]) AS Unique_Orig
FROM [Wires_I-incoming_O-outgoing]
WHERE ([Wires_I-incoming_O-outgoing].Direction="I");
thank you!