Concatenate in a query

[afs24]

I have two fields:
Name
ID

I want to concatenate these two feilds in a query?? Could you provide me with an example?

 

[afs24]

I'll try and give a better example:

My fields are:
Name ID
Jason 555

The output should look like the following:
Name555 or Name 555 (spaces if possible)

I'm trying this but its not working:
concatenate[NAME]," ",[ID]

 

[dk]

Hi,

You should be able to use something like:-

YourExpression: [TableName]![Name] & ' ' & [TableName]![ID]

Where TableName should be the name of your table.

HTH
Dan

 

[afs24]

I tried this but it's still not working? I get a pop up asking me to enter in the table and field.....

[E3SSTSA]![ISTOR] & "" & [E3SSTSA]![IITEM]