No result in query from Access

[Jennypi]

Hi,

One of my reports is based on a query in an Access DB.
At first, it was working, but then the user slightly modified the query, by adding another filter or parameter. So now it shows no results, although there are results when we run the query in Access directly.
When we try to base the source on another query, it is working perfectly, data are well retrieved.
So it seems there is a problem with this specific query, but we could understand what.

I am attaching some pictures:
- the query in SQL mode (in Access)

query.PNG (14.17 KiB) Viewed 927 times

- The results of the query (in Access)

query_results.PNG (94.88 KiB) Viewed 927 times

- the query defined in Stimulsoft, which show no results when I click View Query. (other queries work perfectly fine when defined the same way)

query_stim.PNG (43.19 KiB) Viewed 927 times

Do you see something wrong? Can a special character make the query fail?
Thanks for your help.

[Alex K.]

Hello,

Can you please send us a sample with test data which reproduces the issue for analysis.

Thank you.

[Jennypi]

Thanks for your reply.
We eventually decided to have directly the tables as the datasource (the query is done in Stimulsoft), and it's working fine now.
I guess Stimulsoft doesn't like the way SQL queries are written in Access, when we retrieve directly from a query.

[Alex K.]

Hello,

Ok.
Let us know if you need any additional help.

Thank you.