what does =llf([District]) do in a report

D

Damon Heron

You've looked everywhere? Including the Access help?
anyway,
IIF is a function
IIF(expr, truepart, falsepart)
like:
sometxtbox =(somenumber > 1000, "true", "false")
where it tests a variable (somenumber) and returns true or false if value is
greater than 1000.
your function is missing the required true and false parts.

Damon
 
M

MichaelTX

The reason your not finding anything is because you're typing 'LLF' (llf)
instead of 'IIF' (iif). This stands for an 'Immediate If' function.

It has three parameters. The criteria, value if true, and value if false.

For example:

IIF([myfield] > 10, "This is a large number", "This is a small number")

This would be similar to typing:

Public Function fctCheckNumber(intNumber As Integer) As String
If intNumber > 10 Then
fctCheckNumber = "This is a large number"
Else
fctCheckNumber = "This is a small number"
End If
End Function
 
Top