I have a client who is opening an office in the UK. His access accdb including forms, query statements (like between), filters etc all use the short date format for the US. Now with the office in the UK they use an international format.
We are getting errors on some queries contain between, form field filters.
Any thoughts on how I can accommodate both offices with the same database and forms/queries?