2 tables - Need time diff....

[goldfishhh]

Table 1:

Job Name, Job down date (and a bunch more things)

Table 2:

Issue description, Issue enter date (and a bunch more things)

The Job name in table 1 is somewhere within the Issue description of table 2. There can be text before and/or after the job name in the Issue Description of table 2.

I need to find out the time between the Job Down date from table 1 and the Issue enter date of Table 2.

Help Computer!

 

[Madawc]

DateDiff includes the ability to find the difference in minutes, hours or seconds.

If that's not it, please clarify

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[goldfishhh]

Yea - I looked into it a bit further and it appears if I were to relate any tables, it would be a "many to many". I can have a single failed job fail multiple times. There is no way to distinguish which job took a certain period of time to open.

Looks like I gotta attack it a different way (tag the failure with a unique number which is shared by both tables.)