|
| 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
July 8th, 2004, 04:04 PM
|
|||
|
|||
Replace blanks by text
How can I replace blank cells with the word "empty" in the
results from a query. 
|
|
#2
July 8th, 2004, 04:11 PM
|
|||
|
|||
|
Replace blanks by text
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" wrote in message ... How can I replace blank cells with the word "empty" in the results from a query.
|
|
#3
July 8th, 2004, 04:28 PM
|
|||
|
|||
|
Replace blanks by text
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" wrote in message ... How can I replace blank cells with the word "empty" in the results from a query. .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do you insert a page break after a text box | Betty Sutton | Page Layout | 3 | June 9th, 2004 03:05 PM |
| Edit same text in multiple locations | angelo11 | Formatting Long Documents | 2 | May 19th, 2004 06:24 PM |
| Text Box in table woes. :( | JOE | Tables | 10 | May 5th, 2004 01:21 AM |
| Is there a way to avoid that Excel add quotes to text when exporting a sheet? | Dario de Judicibus | Worksheet Functions | 5 | January 11th, 2004 09:26 PM |
Linear Mode
