Posted by jmartineau on 11/28/05 21:30

Ah, this sort of thing is exactly what I need. However, when I modified
the query you gave to fit the particular table names, etc, I now have
an error: "Missing Keyword" at this point:

FROM LoanBalanceTable) AS b ON a.Account# = b.Account#
**

Do you know what would cause this? Thanks,

• Next in forum: Re: CASE problem
• Prev in forum: Re: CASE problem
• Thread view: Re: difficult summing query

[Reply to this message]