Sylvie
Use of ALL CAPS suggests shouting ... did you mean to "shout"?
If your query is working without giving an error message, but returns no
rows/result, it may be because your query is doing exactly what you are
telling it to do.
You didn't share your SQL or your data structure, so it could be tough to
diagnose what isn't working. Is there any chance your underlying table has
a field defined as a "lookup" data type? If you have this, you may not
realize that what Access stores and what it displays are two different
things. So if you are trying to query on one of these lookup data type
fields, you may be searching for something that actually isn't there?!
