My issue is now resolved, Many thanks.

Hi,

Thanks for your last reply. Apologies for the delay in replying I have been attempting to complete the query myself, unfortunately without any luck.

The message that is displayed...

Hi,

Thanks for your reply.. Here's where I'm stuck at, I have the query below in place.

select ' ';

SELECT

DATE,

NAME,

sum(TOTAL),

FROM TABLE1

WHERE (DATE > @date1 AND DATE < @date2 )

...