OK, here is the problem I'm trying to get this formula to work, maybe someone can help here is the current formula I have:

if {Call_Times.Time_Master_PKey} = 130000140
then {Call_Times.DateTime);

Here is my problem..
This is what the table I'm looking at looks like its called Call_Times:

Pkey          |Time_Master_Pkey| DateTime
---------------------------------------------------------------
130100091 | 130000139           | 2/3/1997 3:25:00 PM
130100091 | 130000140           | 2/3/1997 3:25:00 PM

Right now I have another table that supplies the Pkey and the above formula should be looking for the Time_Master_Pkey then when it finds it then returns the DateTime Column to be displayed but it doesn't matter what I put in for Time_Master_Pkey if it equals true it just prints the first row of the return. Can someone tell me how to make it so that when Time_Master_Pkey = value x return DateTime for that row or do I have to do it another way.

Edited by Pyrotecnix - 28 Jun 2010 at 11:14am

I'm well aware of the join for a link between the two tables. I have linked the pkey from the other table to the call_pkey in this table you are seeing it will list all the separate records based on that if I drop it in detail but I need them all in one area which is why I was trying to create a formula that will say if time_master_pkey is equaled to this then display this record from the row it matches, the record being the calldate. I have been researching it and people are saying that I would need to do a sub report possibly, but not sure at this time.