Search results

I have 2 tables, UST_PXs and MTG_PXs and I'm trying to return the date in MTG_PXs based on the ID in UST_PXs...I have been trying DMAX without luck and I can get the right record using MAX, but that's an aggregate and I can't just tack a -2 or -5 on the end of it. Does anyone have any...

So I have the SQL code below which helps me determine the change in DACE....now I want to incorporate another table "Loans"....where I want to figure out how to sum all loans that have a "C" or a "3" in the field "Status History" for a given month I have a query that does what I want, but I am...