In what table can I find this?

 
Author
Message
Elite SysAider
234
 
Hi everybody,

I'm using Acces for my reports. Now I'm looking for the table that contains the start/end time and the total of the activity in the SR page.
See attachment for clarification.

I searched almost every Table (SQL) but I can't find the fields as seen on the activity tab...

Kind regards,
René

Edit: Sorry I forgot to attach the image.

This message was edited 1 time. Last update was at Nov. 04, 2008 03:51 PM

Take a look at my 3D creations and here is a little animation I made
SysAider
24
 
Hello René,

Activities for Service Requests are stored in work_report table, for Tasks in task_activities table. Total time is a calculated value though not a stored one.

Best regards
Andreas

This message was edited 1 time. Last update was at Nov. 05, 2008 09:58 AM

Elite SysAider
234
 
Thanks andreas.

How could I miss that one.


Kind regards,
René
Take a look at my 3D creations and here is a little animation I made
SysAider
24
 
Maybe because it's the last one in alphabetical order
That or it sounds like something related to reports and not activities.

Best regards
Andreas
Elite SysAider
234
 
Haha yeah indeed. I was looking at tables with SR in the name.
Anyway I found it and linked the SQL table in Access.
Now I've encounterd another problem. LoL... But I won't start asking again....

Kind regards,
René
Take a look at my 3D creations and here is a little animation I made