Inserting Function as Feild in Query

[Ragnar78]

Hy,

I want to add a feild in my query that is calculated by a function in my modules.

So my query goes like this

Select Feild1, Feild2, Feild3, MyFunction(Feild2) into Table 2 frOm Table1

Can i write the code like this? cause i've been having some difficulties launching the query...
Does the variable in MyFuction should not be a feild selected in the query?

Thanks again

 

[Dugantrain]

Yes, this is possible, you can use a VBA function and write the results of that function to a table. If you're getting errors, it may be because there is an error in the function or because you are trying to pass in or return Nulls (which is possible to do, you just have to make sure that you declare everything in the Module as Variant). Of course, it may also be a problem with your SQL, in which case I'd use Access's Query-Builder to build a Make-Table query and just add in your function-generated field there.

 

[Ragnar78]

I have problems with the wizards...(Class not Registered Topic)...i have to retype most of the codes (good training, but go figure them out when you're a n00b)

Thanks again for the help, i'll just Set the Type of the feild and check the result of the function to be of the same type...i think as you said this might be the problem...

Thanks again

 

[Abulafia]

You might want to specify what fields you are appending this information to.