Hello,
I have been asked to build functionality that will allow a user to run a report on a Sharepoint list. The list contains a quater / year field (1Q2014) and the record on the list can contain multiple values (1Q2014, 2Q2015).
I am new to Sharepoint, and not an expert in Access.
Where should I start?
Should I create the database, then link to Sharepoint, or vice-versa?
Once the link is establised, I need the user to open the tool (form / query / report), select the quarter desired, and have the report display the data related to the selected quater.
I apologize in advance, but I will need some specific directions on the linking, user quarter selection and the form / query / report setup.
The user should be able to access the functionality through the Sharepoint site and not have to download a copy to the user's machine.
Any guidance would be greatly appreciated.
Thanks,
Marc