Expression Builder

[mcp201]

I am trying to use Expression Builder to concatenate certain fields. Can
anyone tell me how I would start the expression? Thanks in advance.

 

[BruceM]

I wouldn't bother with Expression Builder. In an unbound text box you can
add something such as:
=[LastName] & ", " & [FirstName]
You could also concatenate in a query.
To answer your question to the extent I can (not having found much use for
Expression Builder), once you know the syntax and the fiedls, etc. you can
assemble the pieces with Expression Builder by clicking, say, the = sign,
then drilling down through Tables until you find the field, then adding an
ampersand and quote marks and more fields or whatever exactly you need.

 

[vbasean]

I am trying to use Expression Builder to concatenate certain fields. Can
anyone tell me how I would start the expression? Thanks in advance.

concatenating strings is basically linking them together

"conjuctioin junction what's your function"

use the amperstand "&" between pieces of text that you want to put
together

remeber that adding two fields directly together gets results like
this

[tablename].[fieldname] & [tablename].[fieldname2]
JamesJones

you'd probably want a space

so use something like this

AnAliasName: [tablename].[fieldname] & " " & [tablename].[fieldname2]

http://www.techonthenet.com/access/queries/concatenate.php

 

[vbasean]

I am trying to use Expression Builder to concatenate certain fields. Can
anyone tell me how I would start the expression? Thanks in advance.

here's another example

http://wagda.lib.washington.edu/gishelp/tutorial/AccessConcat.pdf

 

[Jeff Boyce]

Where? (as in "where are you trying to do this?")

What? (as in "what data/strings/values are you trying to concatenate?")

Regards

Jeff Boyce
Microsoft Office/Access MVP