I have a table that contains the "C

[ronwmon]

I have a table that contains the "Company Bame" and the "Company Number". I import a table from a supplier that contains the company number as UserID. My company number is a number, the supplier has the UserID as text.

I want to include the company name in a report. I have a query that collects the data I want for the report but I can't figure out how to to select the company name, I need the UserId as a number. I have tried Cint(userid) but get verious errors such as "Invalid use of null."

Any ideas are appreciated.

Ron--

 

[Andrzejek]

Do you have some userid's as NULLs?
If so, investigate NZ function to turn those NULLs into 0, for example

Have fun.

---- Andy

 

[ronwmon]

Yes, I do have some userid's that are nulls. I'm not familure with the NZ function but I will do a search and see what I find.

Thanks

 

[ronwmon]

Andy,

The NZ function worked great. Thanksa.

Ron--

 

[Andrzejek]

Glad to help

Have fun.

---- Andy