Hi Steve,

wrap field references with NZ (convert Null from nothing to
something) in case they are blank

ie:
Left
(
nz([expression]),
Len(
nz([expression])
)
-Len(
nz([expression])
)
)
....

if that doesn't work, then tell me the SQL of your query and
I will give you another method


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

Steve wrote:
Yes, it is.
InitialWI:
Val((Left([expression],Len([expression])-(Len([expression])-InStr(1,[expression]," ")+1)))/100)

"strive4peace" "strive4peace2006 at yaho" wrote:


Hi Steve,

Is that column a calculation?


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

Steve wrote:

Doing a simple query where I join a master table with all records and a query
that creates a subset of data. When I look at the result set after the join,
the master table records that aren't present in the subset have #error for
that column. My environment is Access 2002 on Xp Pro with all os and office
updates current. I've been doing this for some time and this is the first
time I've seen this. Thanks in advance for you help.
Steve