Need help on Oracle Forms 6i

Dear all,

I have 2 tables:
-Table USER_ with columns ID, NAME and STATUS
-and table COMMAND with columns ID, TIMESTAMP and USER_ID.
I want to create a form that will count all commands of each user for a certain period of time. The form must have 2 fields (DATE1 and DATE2). The results (user name and number of commands) must be presented on a table in the form.
I created a Block (KOSTAS_BLOCK) based on a query "select u.name name, count(c.id) requests_served from user_ u, command c where u.id=c.user_id group by name"
Then I set a button and WHEN-BUTTON-PRESSED I tried to run
"SET_BLOCK_PROPERTY ('KOSTAS_BLOCK',
default_where,
'TIMESTAMP between ATE1 and ATE2');
go_block('kostas_block');
execute_query;"

When I try to run the form I get the error message that query cannot be executed.
Can anybody help me on that.
Thanks in advance

Add the timestamp condition in ur query.....
The date1 and date2 fields are actually the input fields on ur form as per my form(correct me if required_

If I understood well your proposal, you want me to add the timestamp condition in the initial select query. The problem is that I cannot add the timestamp condition in the initial query, since I have the "group by" condition at the end of it.

I want u to add this condition in the where clause//// so that should not be a prob