convert expression to public

[azhar2006]

Hello guys
Is it possible to convert this expression to a public function Or code vba .
Thanks in advance

Field: IIf([Expr1]>=[Params1];[Computer];IIf([Expr1]>=[Params2];[Maths];IIf([Expr1]>=[Params3];[Statistics];IIf([Expr1]>=[Params4];[Medical];" "))))

Expr1
SELECT [TotalScores]/7 AS Expr1, IIf([Expr1]>=[Params1],[Computer],IIf([Expr1]>=[Params2],[Maths],IIf([Expr1]>=[Params3],[Statistics],IIf([Expr1]>=[Params4],[Medical]," ")))) AS Field, Right([yars],2) & "" & [NoAccepCentral] & "" & [field] AS Expr2, [Field] AS uu, tbStudents.StuID, tbStudents.NoAccepCentral, tbStudents.yars, tbStudents.StudentName, tbStudents.FigAla, tbStudents.City, tbStudents.HighSchool, tbStudents.Branch, tbStudents.TotalScores, tbStudents.University, tbStudents.Computer, tbStudents.Maths, tbStudents.Statistics, tbStudents.Medical
FROM tbStudents, Table2;

[June7]

A public function is VBA code.

The function would have to open a recordset or the values in all nine fields would have to be passed as arguments of the function.

Why would you want a function when this is a fairly simple expression and all the necessary values are available in the query?

[azhar2006]

Thank you John
I have text boxes on the form I want quick access to the values ​​of this expression

[June7]

I don't really understand how a function will assist with that.