Interactive date range?

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

Seadog 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 http://www.knowledgewave.com/blog/mso...

Does anyone know how I can do this please?

Thanks in advance

edit retag flag offensive close merge delete

Comments

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 +0200 )edit