Skip to Content
0
Former Member
Jan 24, 2011 at 02:04 PM

Q34 - Adding DocDueDate...........aarrrggghhhhhh

38 Views

Can anyone explain why I get an error message when I try to insert:

t1.docduedate between [%1] and [%2]

or even

t1.docduedate >= '[%0]' and <= '[%1]'

into the 'WHERE' statement below.............

SELECT

t1.cardcode, t1.cardname,

sum(t1.doctotal-t1.vatsum) as 'Sales Value'

FROM

ordr t1

WHERE

t1.docstatus = 'O'

GROUP BY

t1.cardcode, t1.cardname

I find this even more confusing as everything is coming from a single table..........!!

Thanks,

Robin