I have been programming for several years in Access and have recently begun to program in VB.

In Access I can include a global function within an SQL statement to manipulate the selected input data to output a new (usually reformatted) field. For example, depending on the value of a [Member Type] field I can format the [Member Name] as [Title Description + First Names + Surname] or [Rank Description + First Names + Surname] where [First Names] and [Surname] are fields in the [Member] table and the Title and Rank Descriptions are held in separate tables.

When I try to do the same thing in VB I get the error - Undefined function 'AAA' in expression!

Is there any way in VB I can code an SQL statement to manipulate the selected input to produce a new formatted field?