Combining Fields in a Query

[Moustrik2001]

I'm combining fields in a query for reporting purposes and cannot figure out how to include spaces or other punctuation in the new field. The following is an example of the current expression. Thanks in advance for your help.

DESCRIPTION: [ProjectOwnerCompany]![NAME] & [RFQDETAILS]![GMFSOW] & [COMPONENTS]![COMP1] & [COMPONENTS]![COMP2]


Moustrik2001
beckyblue@cableone.net

 

[traingamer]

DESCRIPTION: [ProjectOwnerCompany]![NAME] & " " & [RFQDETAILS]![GMFSOW] & ";" & [COMPONENTS]![COMP1] & [COMPONENTS]![COMP2]

etc. etc.

traingamer

 

[PHV]

Some examples:
DESCRIPTION: ProjectOwnerCompany.NAME & ', ' & RFQDETAILS.GMFSOW & ': ' & COMPONENTS.COMP1 & '!' & COMPONENTS.COMP2


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244