Have blank fields - but want to force data in?

[tinkertoy]

I have a field that comes across blank there is no data, but in the query, if the field is blank I want to force a specific string into it. I tried IsNull and IIf expression, and a combination of, but, I get a data type error or no data at all. The field is a Date/Time Field, and if it is Null then I want to put a default date in of 01/01/1901. The date doesn't really matter, it is just necessary to have data in it. thanks!!

 

[Trendsetter]

I "think" that you may be trying to fill data into the many side of a relationship when a record doesn't exist.
Your problem would be at the table level not the query level and if this is so, you could put a default Value in the table to make sure it always gets what you want.

 

[mikevh]

Haven't seen your SQL, but the following should
show 01/01/1901 if the field is blank, the contents
of the field otherwise. ("YourDate" represents the
name of your date field):

IIf(nz([YourDate])=0,#01/01/1901#,[YourDate])