Query Blank Values

[kgbo]

I have created a query that is connecting 3 tables together. These tables are connected to an Excel spreadsheet that when the spreadsheet is changed, the table in Access automatically updates.
Sometimes a cell in Excel is left blank. Is there a way for the query to change it from a blank cell to the word "Unknown" ?

[June7]

Try:

Nz([fieldname], "Unknown")

[Dal Jeanis]

Are you asking to update the source Excel spreadsheet, or just change what appears in the query? If the latter, user June's method.