If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
what does =llf([District]) do in a report
I've looked everywhere and cannot find out what the "=llf" means or does.
|
#2
|
|||
|
|||
what does =llf([District]) do in a report
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 "El Boracho" wrote in message ... I've looked everywhere and cannot find out what the "=llf" means or does. |
#3
|
|||
|
|||
what does =llf([District]) do in a report
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 --------- El Boracho wrote: I've looked everywhere and cannot find out what the "=llf" means or does. |
Thread Tools | |
Display Modes | |
|
|