Interactive date range?

asked 2018-01-30 12:22:10 +0100

Seadog gravatar image

updated 2020-07-10 21:17:53 +0100

Alex Kemp gravatar image

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

edit retag flag offensive close merge delete


Ok so I can set the query up as a parameter query, where a pop up box will ask me for a start and end date, which is great and does what I need. However for a better user experience I would like the user to be able to select the dates from a drop down, preferably in a form, is this possible?

Seadog gravatar imageSeadog ( 2018-01-30 12:31:55 +0100 )edit