mnemtsas
Site Admin
Joined: 08 Mar 2004
Posts: 626
|
 Posted: Mon Feb 20, 2006 11:13 am Post subject: Search Database - Easy Reports |
 |
|
The search database functionality on the Tools->Options->Search Database menu allows you to create simple reports with some knowledge of SQL.
If you don't have any SQL knowledge then never fear. In the latest version of Timesheets MTS you can save and retrieve queries so I hope that this thread will become the repository for useful queries that you the users of Timesheets MTS have come up with. I'll kick things off with:
| Code: |
SELECT tblProjects.strProjectNumber,tblProjects.strProjectName,tblProjects.strProjectDescription,tblCustomers.strCompanyName FROM tblContacts INNER JOIN tblProjects ON tblContacts.lngContactID=tblProjects.lngContactID WHERE tblProjects.blnClosed=FALSE ORDER BY tblContacts.strCompanyName ASC
|
All this does is produce a list of all open projects in your system ordered by client name.
If you want to try this yourself you could try using the query builder in MS Access and then switching to the SQL View. You can cut and paste this SQL code straight into the Search Database form in Timesheets MTS. |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
