How can I replace blank cells with the word "empty" in the results from a query.
S Seaman Jul 8, 2004 #1 How can I replace blank cells with the word "empty" in the results from a query.
W Wayne Morgan Jul 8, 2004 #2 Create the field as a Calculated Field Example field row entry in design grid: Expr1:Nz([tblTable1].[Field1], "Empty")
Create the field as a Calculated Field Example field row entry in design grid: Expr1:Nz([tblTable1].[Field1], "Empty")
S Seaman Jul 8, 2004 #3 Thanks it works ! -----Original Message----- Create the field as a Calculated Field Example field row entry in design grid: Expr1:Nz([tblTable1].[Field1], "Empty") -- Wayne Morgan Microsoft Access MVP Seaman said: How can I replace blank cells with the word "empty" in the results from a query. Click to expand... . Click to expand...
Thanks it works ! -----Original Message----- Create the field as a Calculated Field Example field row entry in design grid: Expr1:Nz([tblTable1].[Field1], "Empty") -- Wayne Morgan Microsoft Access MVP Seaman said: How can I replace blank cells with the word "empty" in the results from a query. Click to expand... . Click to expand...
