I set the variable up as 0 not null
the val() worked a treat
thanks :D
Matt
- Original Message -
From: "EWS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 23, 2004 11:30 AM
Subject: Re: [ cf-dev ] Monday SQL question
> Also, bear in mind
e type mismatch
- Original Message -
From: "EWS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 23, 2004 10:04 AM
Subject: Re: [ cf-dev ] Monday SQL question
Are you sure its the sum causing the error and not the yearid or monthid
On Mon, 23 Feb 20
t;
Sent: Monday, February 23, 2004 10:04 AM
Subject: Re: [ cf-dev ] Monday SQL question
Are you sure its the sum causing the error and not the yearid or monthid
On Mon, 23 Feb 2004 09:40:24 +0200, Matt Horn <[EMAIL PROTECTED]>
wrote:
> Hi
> I have this very simple SQL query
>
&g
the SQL statement works
I get a variable out called qry.total
but when I do
I get the type mismatch
- Original Message -
From: "EWS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 23, 2004 10:04 AM
Subject: Re: [ cf-dev ] Monday SQL questio
Are you sure its the sum causing the error and not the yearid or monthid
On Mon, 23 Feb 2004 09:40:24 +0200, Matt Horn <[EMAIL PROTECTED]> wrote:
Hi
I have this very simple SQL query
select Sum(amount) as total from tbltotals where yearID
=#getyear.yearID# and monthid=#month#
I loop over the
Hi
I have this very simple SQL query
select Sum(amount) as total from tbltotals where yearID =#getyear.yearID# and
monthid=#month#
I loop over the query outputting #qry.total# for each month
I want to keep a running total for that year
but when I try to add it up I get a type mismatch error
