>ok I changed the code to

with datamodule1.IBOquery1 do
begin
if active then Close;
ParamByName('date').asdate := wwDBDateTimePicker1.date;
open;
end;
with datamodule1.IBOquery2 do
begin
if active then Close;
ParamByName('date').asdate := wwDBDateTimePicker2.date;
open;
end;

IBOquery1.SQL
select * from notesdata
where notetype = 'D'
and notedate = :date
order by notetime descending

IBOquery2.SQL
select * from notesdata
where notetype = 'M'
and notedate = :date
order by notetime descending

It still ignores the notetype and retrieves the records for the proper date.

What is wrong with this SQL

help please
Daniel