Anyone here using SQL statements in Jet. need advice

how do i put this inside a NL()?


SELECT [ASIAN DRILLING SERVICES$G_L Entry].[G_L Account No_],
[ASIAN DRILLING SERVICES$G_L Account].[Name],
SUM([ASIAN DRILLING SERVICES$G_L Entry].[Debit Amount]) As Debit,
SUM([ASIAN DRILLING SERVICES$G_L Entry].[Credit Amount]) As Credit,
[ASIAN DRILLING SERVICES$G_L Entry].[Global Dimension 1 Code],
[ASIAN DRILLING SERVICES$G_L Entry].[Global Dimension 2 Code]
FROM [ASIAN DRILLING SERVICES$G_L Entry], [ASIAN DRILLING SERVICES$G_L Account]
WHERE [ASIAN DRILLING SERVICES$G_L Entry].[G_L Account No_] = [ASIAN DRILLING SERVICES$G_L Account].[No_]
AND [Posting Date] BETWEEN '09-01-09' AND '09-30-09'
GROUP BY [ASIAN DRILLING SERVICES$G_L Entry].[G_L Account No_],
[ASIAN DRILLING SERVICES$G_L Account].[Name],
[ASIAN DRILLING SERVICES$G_L Entry].[Global Dimension 1 Code],
[ASIAN DRILLING SERVICES$G_L Entry].[Global Dimension 2 Code]
HAVING
(SUM([ASIAN DRILLING SERVICES$G_L Entry].[Debit Amount]) <> 0
or SUM([ASIAN DRILLING SERVICES$G_L Entry].[Credit Amount]) <> 0 )

is this a right way?

=NL(“Rows”,” SELECT [ASIAN DRILLING SERVICES$G_L Entry].[G_L Account No_],
[ASIAN DRILLING SERVICES$G_L Account].[Name],
SUM([ASIAN DRILLING SERVICES$G_L Entry].[Debit Amount]) As Debit,
SUM([ASIAN DRILLING SERVICES$G_L Entry].[Credit Amount]) As Credit,
[ASIAN DRILLING SERVICES$G_L Entry].[Global Dimension 1 Code],
[ASIAN DRILLING SERVICES$G_L Entry].[Global Dimension 2 Code]
FROM [ASIAN DRILLING SERVICES$G_L Entry], [ASIAN DRILLING SERVICES$G_L Account]
WHERE [ASIAN DRILLING SERVICES$G_L Entry].[G_L Account No_] = [ASIAN DRILLING SERVICES$G_L Account].[No_]
AND [Posting Date] BETWEEN '09-01-09' AND '09-30-09'
GROUP BY [ASIAN DRILLING SERVICES$G_L Entry].[G_L Account No_],
[ASIAN DRILLING SERVICES$G_L Account].[Name],
[ASIAN DRILLING SERVICES$G_L Entry].[Global Dimension 1 Code],
[ASIAN DRILLING SERVICES$G_L Entry].[Global Dimension 2 Code]
HAVING
(SUM([ASIAN DRILLING SERVICES$G_L Entry].[Debit Amount]) <> 0
or SUM([ASIAN DRILLING SERVICES$G_L Entry].[Credit Amount]) <> 0 )
”)