DLast Method

[Fi]

Hi..I'm trying to show the last figure entered in a cell, on a continuous subform. Using DLast I can get the expected figure to appear but it is the last one entered over all records whereas I would like to see the last one for that particular record, the DB has a main form Clients and a subform Deals, the client can have many deals and I would like to show, in the form footer of the subform, the last interest rate used for that particular clients deals....make can anyone help
thanks in advance

 

[Jack Cowley]

Something like this:

X =DLast("[FieldName]", "TableName", "[ClientID] = " & Me![ClientID])

 

[Fi]

thanks for the replies Pat and Jack, I have tried your suggestion Jack in the control source for the cell but it gives me an error message, have I put it in the correct place, should it be an event ? I'm a bit lost about the X, sorry still a bit of a novice.
For the query Pat, should the subforms control source be based on this ? or just the cell ? any more help would be greatly appreciated...thanks

 

[Fi]

Thanks for your reply Pat, I am trying to get this to work but can't seem to get it, I have created a query based on the table that the subform is based on, in properties of the query should I use 'Interest Rate' or 'ClientID' for Order By ? should I base the subform on the query also, or should it still be the table, the control on the form where I want the calculation to appear is in the form footer of the subform, does this make a differance, I have tried help but it was no clearer, if there is anything you can suggest I'd be most grateful, thanks