Criteria issue

[galin]

hi folks,
I have an issue with AND statement.I have ID, NAME,
DATE,PAY in a query. I've created a form which displays
date range and pay codes when a user enters ID or Name.
THE problems is that I can run the query only if I specify
either ID or NAME, but not both at the same time. For
example , I have [Forms]![FormProba]![txtID] and everythig
is fine. But when I have at the same time [Forms]!
[FormProba]![txtID] (in the ID field) AND [Forms]!
[FormProba] I have no results.
I tried putting the [Forms]![FormProba]![txtName]with OR
Criteria,but still no success.
Any suggestons.
I've joined two tables - one from which I get ID and NAME,
and second from which I get DATE and PAY,by joining both
the ID and Name records.

Hope it's not very confusing
Thanks
Galin

 

[John Vinson]

Hope it's not very confusing

I fear that it is. Could you please open the Query in SQL view and
post the SQL text here?

 

[gal]

Thanks for the offered help John,but I found my mistace. I
named wrongly one of my fields whicj in return produced
blank report