Hi,
Can anyone point me in the right direction.
I want to write a function that imports 2 fields from a linked SQL table. fields =(ProductNumber, Price) and import it to a access table but insert a field "customer number" which is defined in the Function header eg Function xyz (custno as string) to every record returned. so the table would have customer number , product number, price for every record.
Ive been searching but cant find anything thats suitable. I was hoping someone could nudge me in the right direction.
Can anyone point me in the right direction.
I want to write a function that imports 2 fields from a linked SQL table. fields =(ProductNumber, Price) and import it to a access table but insert a field "customer number" which is defined in the Function header eg Function xyz (custno as string) to every record returned. so the table would have customer number , product number, price for every record.
Ive been searching but cant find anything thats suitable. I was hoping someone could nudge me in the right direction.