copy a value in my Report from table

[ccguillermo]

I have a report (report-accept and Reject) with Total Accepted and Total Reject field; but I need to get a Value of the field T850 that is on the Table: Kron-info. My question is how I can get the value of this field and Copy in the reports by userID




Thank you very much for you help.


Carlos

[apr pillai]

You can use a DLookup() function in a Textbox where you want it on the report. If the UserID is part of the Report Source data and placed on a control in the detail section then the function can be used here.

=Dlookup("FieldName","Recordsource","UserID = " & [userid])

If you need Summary Value on UserID at the Group-Footer area then use DSum() Function using the same parameter values. If it is for Report Summary then use DSum() function at the Report Footer without the last parameter.

[ccguillermo]

Apr Pillai
thank you for you response I really appreciate you help.
I have a very curious question with the same problem I did the following but I get a error#&
Iff([Reports]![report Name]![userID]=[Table Name]![userID], [Reports]![report Name]![the field T850]) what is wrong with this,

Thank you

Carlos