C# linq count

Question

I would like help with a linq to sql statement in a C# application. I am trying to count the number of occurences in the
Trans table. I am always getting a count of zero.  There is only one record in the IM and IPack tables but there are 1 to hundreds
of records in the Trans table.

var  varGoodTransCount = (from t in rData.Trans
                                         join iw in rData.Im on t.I_ID equals iw.I_ID
                                         join ip in rData.IPack on iw.PID equals ip.PID
                                         where iw.TNum == PkgID
                                         select new { }).Count();

Thus can  you tell what what you think is wrong with the linq query above? Can you suggest how to change it?