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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top