With the student template there is a search bar in the form which is linked to a query. I wished to allow the search bar to search either of the first, last or other names from my records and bring up the correct record.

the codes are:-

File As: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " & [First Name]))

and

Student Name: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))

These are very restrictive as they do not allow searches of the Last Name and I require the addition field of other name/s in the equation .

I am a beginner and sorry if it seems like I am cheating by using template.