My IT Department is tasked with creating a number of FAQ's per month. The challenge in tracking this is when I approved the FAQ, the name that shows on the main FAQ screen changes from the person who created it to my name in the Updated column. I would like to either:
- add the Created By field to the FAQ display screen
- create a report that shows/counts the number of FAQ's created by person for a time period
If you have any experience with SQL, you can use this query as example and modify it for your needs:
INNER JOIN [Helpdesk].[dbo].[TECH]
WHERE [FAQ_DATE] > '2012-12-01'
AND [FAQ_DATE] < '2013-05-01';