Using OR in MSQuery

When looking for data in our Sage accounts program I like to use MSQuery and Excel.
Typically I will use something like this to limit the data to a given month.

|Document _Type| Document_Date|
| 4 or 5 | Between 01/01/2019 and 31/01/2019|
and this will give me all documents of type 4 or 5 during month of January which I want.

However if I perform the query a second time I only get the documents of type 4 and when I look at the query again it looks like_

|Document_Type| Document _Date |
| 4 | Between 01/01/2019 and 31/01/2019|
OR | 5 | Between 01/01/2019 and 31/01/2019|
and this only gives me the documents of type 4. for the month of January
When I look at the SQL statements they are different

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I over come the difficulty by using the correct SQL statement in my code. It would be much easier just to refresh the query. How should I use MSQuery to give me the desired result and stop it changing itself to give the wrong result?
John

As there has been no response to my initial post I am trying to simplify it.

My core problem is that when using MSQuery to get data from Sage Line 100 I get the result I need the first time it is run but it resets itself so I get the wrong result in subsequent runs.
I see that the reason is that the SQL statement is changed from:-
[1]

Please Login or Register  to view this content.

to:-
[2]

Please Login or Register  to view this content.

The correct SQL statement is achieved in MSQuery by making the selection of :-

TRANSACTION_TYPE (4 or 5) and TRANSACTIOIN_DATE(Between Date1 and Date2) using only 1 row of the MSQuery grid and giving the correct SQL statement [1]
This gets changed by MSQuery to
TRANSACTION_TYPE (4) and TRANSACTION_DATE (Between Date1 and Date2)
or
TRANSACTION_TYPE(5) and TRANSACTION_DATE (Between Date1 and Date2) using 2 rows of the MSQuery grid and giving an SQL statement which is wrong [2]

What I would like to know is, is there a way of using MSQuery so that I consistently get the correct SQL statement?
I hope this makes my problem clearer and that some one will be able to help me.
John

Your second option (that MSQuery reverts to) should give the same results as the first one, logically.

I can't see logical difference between two where clauses either.

I suspect, there's some other cause for the difference (such as cursor type etc).

Do you have to use MSQuery rather than Power Query?

If you run both query directly on the db do you get same issue as when queries are run on MSQuery?