Search results

I did read the article but didn't see anything in there which would relate to my particular problem (apart from the bit about unbound fields but I made sure the short date format was in there)

Hi DBguy, I don't think it's an international date issue, more that the query returns results for the days entered but ignores the month and year. To go back to the example if I enter 16/02/2021 to 23/02/2021 I get results for 16/12/2020 to 23/12/2020 and 16/01/2021 to 23/01/2021 and 16/02/2021...

Hi, I have the below where clause to return data from a date range. WHERE ((LEFT(tbl_Triage.TIMESTAMP, 10) >=[Forms]![frm_SearchTransactions]![txtDateFrom]) OR ([Forms]![frm_SearchTransactions]![txtDateFrom] Is Null)) AND ((LEFT(tbl_Triage.TIMESTAMP, 10)...

Thanks, DBguy Tried that and it didn't work Just tried again after closing the form and it works fine. Lesson learned...close the forms before you try new stuff. Did say I was new to access :)

Hi All, I'm new to access and feeling my way in the dark a little. I'm building a form for users to enter parameter criteria and it's coming along nicely. The form is such that a user can enter data for some or all parameters or any combination of them. All good. Here comes the but... In...