Due to the nature of the database - I cant post the actual query. But essentially it's using a pass through query in MS Access directly to the server and written as
SET NOCOUNT ON SELECT field1, field2, field3, Date1 From sqlTBLone WHERE (field1 = 'something') and (Date1 Between '2018/01/28' AND ''2018/02/03')

There's loads more tables with joins, but it's simply written as in the above example