Compile Error

[SysDupe123]

I'm getting a compile error and I've got a basic function in my query. I haven't had this before and I'm at a loss at what to do. This is the entry that is giving me trouble.


Key2: [first name] & [last Name] & Trim(Val(Right([CustID],4)))

How can I get this to work?

 

[VRoscioli]

The use of the Trim() function is unnecessary, as the Val() function returns a number, which cannot have leading/trailing spaces. I'd imagine this type mismatch is what is causing your error.


-V

 

[Remou]

It is hard to tell what parts of this you need:

Trim(Val(Right([CustID],4)))

I imagine

Right([CustID],4)

Would be sufficient.

 

[PHV]

Double check your references:
in the VBE, menu Tools -> References ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SysDupe123]

I tried using just Right([CustID],4) too and it still is giving me a compile error.

 

[PHV]

Have you checked the references of your VBA project ?
Does the database compile properly ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Remou]

Please post the complete line with some context.

 

[SysDupe123]

Thanks PHV! I tried to compile and it worked fine afterwards!