Adding User Define fields together

This is driving me crazy! The SQL Statement refenced is shown at the end of this email.

When I try and run the statement, an error is raised saying that Undrawn_GT5MIL_LE365Days is invalid (likewise for Undrawn_LE5MIL_LE365Days). From what I can gather, it is saying that I cannot include a User Defined variable in another argument. This is unlike Access. Any suggestions?

SQL View......

SELECT TOP 100 PERCENT QRY_FacNew_Term.Category, QRY_FacNew_Term.Fac_No, QRY_FacNew_Term.Client_Number, QRY_FacNew_Term.Client_Name,

Undrawn_GT5MIL_LE365Days = CASE WHEN Undrawn_CDN >= 5000000 AND Term <= 365 THEN Undrawn_CDN ELSE 0 END,

Undrawn_GT5MIL_GT365Days = CASE WHEN (Undrawn_CDN >= 5000000 AND Term > 365) OR

(Cr_Limit_CDN IN (0, 1)) THEN Undrawn_CDN ELSE 0 END, [Undrawn_GT5MIL_LE365Days]+[Undrawn_GT5MIL_GT365Days] AS Total

FROM dbo.QRY_FacNew_Term

WHERE (Exclude <> 'Y')

ORDER BY Category, Client_NameUse brackets if name includes space:

[drawn_GT5MIL_LE365Days ] = CASE WHEN Undrawn_CDN >= 5000000 AND Term <= 365 THEN Undrawn_CDN ELSE 0 END,

Adding static columns to a matrix report?

So I'm making a matrix report. It's driving me nuts, frankly. Here's what I
want to do.
__________|Item Code|Description | Column Group -->
Row Group| | |
---
| | |
|
|
\/
I can get it all working, except for the "Description" column. What I have
now is
__________|Item Code| Column Group -->
Row Group| |
---
| |
|
|
\/
Which works fine. I cannot, for the life of me, add another "static" column
for the Description (that does not get repeated with the column group). I
hope this is clear enough for someone to offer me a suggestion, and I hope
posting doesnt mess up the linbreaks... Thanks in advance!
Peter L.Try this ..
Right click on filed below column group. choose add row.
It will add new column on left. Then delete the cell below the column field.
which will delete added row below but coloum on left will remain as it is.
"plandry@.newsgroups.nospam" wrote:
> So I'm making a matrix report. It's driving me nuts, frankly. Here's what I
> want to do.
> __________|Item Code|Description | Column Group -->
> Row Group| | |
> ---
> | | |
> |
> |
> \/
> I can get it all working, except for the "Description" column. What I have
> now is
> __________|Item Code| Column Group -->
> Row Group| |
> ---
> | |
> |
> |
> \/
> Which works fine. I cannot, for the life of me, add another "static" column
> for the Description (that does not get repeated with the column group). I
> hope this is clear enough for someone to offer me a suggestion, and I hope
> posting doesnt mess up the linbreaks... Thanks in advance!
> Peter L.|||That only adds another row below... I think that's how I got the first Item
Code column. It just won't let me add another column, no matter how many rows
I add...
"Vinay" wrote:
> Try this ..
> Right click on filed below column group. choose add row.
> It will add new column on left. Then delete the cell below the column field.
> which will delete added row below but coloum on left will remain as it is.
>
> "plandry@.newsgroups.nospam" wrote:
> > So I'm making a matrix report. It's driving me nuts, frankly. Here's what I
> > want to do.
> >
> > __________|Item Code|Description | Column Group -->
> > Row Group| | |
> > ---
> > | | |
> >
> > |
> > |
> > \/
> >
> > I can get it all working, except for the "Description" column. What I have
> > now is
> >
> > __________|Item Code| Column Group -->
> > Row Group| |
> > ---
> > | |
> >
> > |
> > |
> > \/
> >
> > Which works fine. I cannot, for the life of me, add another "static" column
> > for the Description (that does not get repeated with the column group). I
> > hope this is clear enough for someone to offer me a suggestion, and I hope
> > posting doesnt mess up the linbreaks... Thanks in advance!
> >
> > Peter L.