Criteria and instructions in an expression

[Linda RQ]

Hi Everyone,

Access 2003. I have this expression in my query which is used for a report.
If the DOB field is blank, I would like to insert the word Need DOB. How
can I do this using my query grid?

PtNameRmAdmitNum: [PtLocRmNum] & " " & [BedNumber] & " " & [PtLName] &
", " & [PtFName] & " ( " & [AdmitNum] & ")" & " " & [PtDOB]

Thanks,
Linda

 

[John Spencer]

PtNameRmAdmitNum: [PtLocRmNum] & " " & [BedNumber] & " " &
[PtLName] & ", " & [PtFName] & " ( " & [AdmitNum] & ")" & " " &
Nz([PtDOB],"Need DOB")

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Linda RQ]

Thanks John..What does NZ stand for...It means if Null?

PtNameRmAdmitNum: [PtLocRmNum] & " " & [BedNumber] & " " & [PtLName]
& ", " & [PtFName] & " ( " & [AdmitNum] & ")" & " " & Nz([PtDOB],"Need
DOB")

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Hi Everyone,

Access 2003. I have this expression in my query which is used for a
report. If the DOB field is blank, I would like to insert the word Need
DOB. How can I do this using my query grid?

PtNameRmAdmitNum: [PtLocRmNum] & " " & [BedNumber] & " " & [PtLName]
& ", " & [PtFName] & " ( " & [AdmitNum] & ")" & " " & [PtDOB]

Thanks,
Linda

 

[John Spencer]

NZ is a function that returns the value in the first argument unless
that value is Null and then it returns the value specified in the second
argument.

I believe NZ is an acronym for Null To Zero (changes nulls to zero).



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Thanks John..What does NZ stand for...It means if Null?

PtNameRmAdmitNum: [PtLocRmNum] & " " & [BedNumber] & " " & [PtLName]
& ", " & [PtFName] & " ( " & [AdmitNum] & ")" & " " & Nz([PtDOB],"Need
DOB")

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

Hi Everyone,

Access 2003. I have this expression in my query which is used for a
report. If the DOB field is blank, I would like to insert the word Need
DOB. How can I do this using my query grid?

PtNameRmAdmitNum: [PtLocRmNum] & " " & [BedNumber] & " " & [PtLName]
& ", " & [PtFName] & " ( " & [AdmitNum] & ")" & " " & [PtDOB]

Thanks,
Linda