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