update query

[ggreg]

I place the lines below in the update area of the query and I get a type coversion error

[-insp].[insp_nm] & Space(30-Len([-insp].[insp_nm])) & [cross_match].[employeenumber]


how can I make this work its seems not to like the (30-Len.....
if I put a number in instead of trying to minus it will work how can i get it
to work by figuring the number in the string?


thanks

 

[WayneRyan]

ggreg,

I think you're feeding the Space function a negative argument. Some of your
data is probably more than 30-characters.

Wayne

 

[ggreg]

thanks Wayne!