I will first explain the current database features I have in place.
The Database contains a form (frm_certreq)
with a field (fld_compdate)
which is filled in with the current date when a button is pressed, marking the document as completed.
The date output is in the format dd/mm/yyyy using the code -
I currently have a view (view_compdate) which lists all the completed documents. The first collumn showing the fld_compdate
I wish to setup a way in which users can filter this view by month and year in order to have the ability to export monthly results for statistical purposes.
Any ideas or suggestions you have will be great in aiding my advancement with this database.