Invalid use of Null 1

[student4life]

Hi, I have Access 2003, and XP SP2. I have a problem executing the query. When I try, I receive an error that says:Invalid use of Null. Any ideas?


BS_Diam: String(CInt([rva_BS_Data]![Diam]*25),ChrW(9644))

Any help would be appreciated.
Thanks!

 

[rjoubert]

Somewhere in your table, the value for [rva_BS_Data]![Diam] is empty (null). What is the datatype for your Diam field?

 

[PHV]

either:
BS_Diam: IIf(IsNull([rva_BS_Data].[Diam]),Null,String(CInt([rva_BS_Data].[Diam]*25),ChrW(9644)))

or:
BS_Diam: String(Nz([rva_BS_Data].[Diam]*25,0),ChrW(9644))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[student4life]

PHV,
You are a genius.
Thank you