Re-using a query by inputing date.

[suverman]

Hello.


The sql I have written is

select sum(amount) from TABLEA where cheque_dt = &che_dt;
And I input 31/05/2011

Just doesnt work.


All I get is a blank cell.

But if I give this

select sum(amount) from TableA;
It gives me the sum of the field amount.



How do I query so that I can input 2 fields in the AND clause, which I would input.

[NTC]

not sure I understand your post; are you building the query using the design grid?....if not - do so.