Hi, I am not able to find the list of issues of items at any given point and also the transaction details for the specific period which is neede from the audit point of view.Could anyone please help me out. -- Priyanka
Priyanka Mishra said:
Hi, I am not able to find the list of issues of items at any given point and also the transaction details for the specific period which is neede from the audit point of view.Could anyone please help me out.
I usually just use a MySQl query, something like: SELECT itemtype, COUNT(itemtype) AS count FROM statistics WHERE YEAR(datetime)=2005 AND MONTH(datetime)=11 AND branch='APL' AND type='issue' GROUP BY itemtype; If you know a little about MySQL, you can create just about any report you want. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
participants (2)
-
Priyanka Mishra -
Stephen Hedges