G
Guest
I've set up a dialog form with 5 fields, client, dept, description, date
from, and date to. In the query where I want to set these 5 criteria I've
entered as [Forms]![Movements Dialog]![Client] and the same for the other 4.
On the 2 criteria for dates I'm using >= on the date from and <= on the Date
to. Its working well until I try to use the * in the dept and in the
description criteria as Like "*[Forms]![Movements Dialog]![Dept]]*". The
user, when entering the criteria in the dialog form for description, would
enter "loan" to see the records like personal loans or loan settlements and
would also enter the date range. It only works correctly if I don't use the
"*" the dept and description criteria entered matches the record exactly.
I'm using Access 2002-3 and the correct ANSI standard. I don't know how to
code and limited to the wizards in access and the macros. Can anyone please
help
from, and date to. In the query where I want to set these 5 criteria I've
entered as [Forms]![Movements Dialog]![Client] and the same for the other 4.
On the 2 criteria for dates I'm using >= on the date from and <= on the Date
to. Its working well until I try to use the * in the dept and in the
description criteria as Like "*[Forms]![Movements Dialog]![Dept]]*". The
user, when entering the criteria in the dialog form for description, would
enter "loan" to see the records like personal loans or loan settlements and
would also enter the date range. It only works correctly if I don't use the
"*" the dept and description criteria entered matches the record exactly.
I'm using Access 2002-3 and the correct ANSI standard. I don't know how to
code and limited to the wizards in access and the macros. Can anyone please
help