How do you do this?

[Nirious]

I have a table with two columns ( OrderNr and Client)
So lets say I have in this table three records:

ORDER          CLIENT

100001         AA0001
100002         RA0005
100003         BV0034

I would like to have them printed(or just shown on screen) like this:

100001/AA0001;100002/RA0005;100003/BV0034

is there a way to get this done?

 

[ecniv]

using vba code - yes.

Via sql statement, not likely....

Select [Field1] & "/" & [Field2] as [newname]
From [table]

Vince

 

[KeithWilliams]

Write a query on the table with an expression OrderNr & '/' & Client.

Should do the trick...
Keith.