How to include two calculated fields in crosstab q

[NZArchie]

Hi there, thanks for looking.

I'm trying to create a crosstab query which gathers fields from two different queries. With one query it works fine, providing summaries of all payments for each advisor, by payment type:

PARAMETERS [Forms]![Advisor Summary Request]![txtToDate] DateTime, [Forms]![Advisor Summary Request]![txtFromDate] DateTime;
TRANSFORM Sum(AllPaymentsForPeriod.[AmountIncGST]) AS SumOfAmountIncGST
SELECT AllPaymentsForPeriod.[FullName], Sum(AllPaymentsForPeriod.[AmountIncGST]) AS [Total Of AmountIncGST]
FROM AllPaymentsForPeriod
GROUP BY AllPaymentsForPeriod.[FullName]
PIVOT AllPaymentsForPeriod.[PaymentMode];

However, when I want to add another query to the source to find totals for payments with certain payment types, it
a) takes a long time to calculate
b) calculates a VERY different number, 100s of times more than there should be

I tried DSum, but how can I link that to Advisor name??

the code with a second source is

PARAMETERS [Forms]![Advisor Summary Request]![txtToDate] DateTime, [Forms]![Advisor Summary Request]![txtFromDate] DateTime;
TRANSFORM Sum(AllPaymentsForPeriod.[AmountIncGST]) AS SumOfAmountIncGST
SELECT AllPaymentsForPeriod.[FullName], Sum(AllPaymentsForPeriod.[AmountIncGST]) AS [Total Of AmountIncGST], Sum(AllNBForPeriod.GST) AS SumOfGST
FROM AllPaymentsForPeriod, AllNBForPeriod
GROUP BY AllPaymentsForPeriod.[FullName]
PIVOT AllPaymentsForPeriod.[PaymentMode];

Thanks again for looking, and for any help

Arch