Prompt in SQL list

Hi all, I don't know if I'm being terminally stupid (very probably) but...

I have a Graphic Table Report to output Concrete Cube Test Results, tested on a date specified at output via a Report Var. CUBEDATA being the parent table with data about the cube to be tested, CUBERES being the child with the results of the test. The report works really well but I can't get one small part to work. 

In the footer is some general bumph about accreditations etc and below that I want to be able to list Project level remarks (easy, as there is only one Project level remark field) and below that I want to be able to list any remarks that are stored in the CUBEDATA table remarks field, relating to specific Cubes. I am using:-

<<SqlList(<<CR>>,_
Select [CUBEDATA].[CubeRem] _
From [CUBEDATA] _
Where [CUBEDATA].[PointID] = '<<PointID>>' _
And [CUBEDATA].[CubeTestDt] = '<<Report Var.Prompt>>' _
)>>

If I don't use the "And" part, the query works fine, but outputs all the remarks for the whole project, not just the ones being reported in the body of the report 

(<<Report Var.Prompt>> asks for a date at output and only outputs results that were tested on that date)  

My question is, is there a way to make the SqlList function take any notice of the result of the prompt?

Miles