Hi
Got a strange one:
In a query Ive put the function below.
AccRef: IIf(IsNumeric([BP3]),Format([BP3],"000",[BP3]))
the problem is if the field BP3 contains eg 3D4, access appends it as 30000. It also classes it as numeric rather than string. Both field in both tables are text . Can anyone think of away round it. I think it has something to do with acess trying to truncate large numbers.
Strange, very strange
Any help is apprciated
Got a strange one:
In a query Ive put the function below.
AccRef: IIf(IsNumeric([BP3]),Format([BP3],"000",[BP3]))
the problem is if the field BP3 contains eg 3D4, access appends it as 30000. It also classes it as numeric rather than string. Both field in both tables are text . Can anyone think of away round it. I think it has something to do with acess trying to truncate large numbers.
Strange, very strange
Any help is apprciated