I have a table in my database with bank transactions.
I can write a simple query to return transactions within a date range, e.g. 01/01/2016 to 31/12/2017.
However I would like to have a form which allows the user to select a date range for themselves, with ‘start date’ and ‘end date’, which would then display said transactions in a table within the form.
I think this is fairly easy in MSbase
Does anyone know how I can do this please?
Thanks in advance