Hi newbie with a problem iv been trying to fix for a week with no luck please help!!!
i have a form with a simple list with a customers first and second name. on the form i want to create a new field joining the first and last name into just a name field.
i have tried calculating from the related table (first name+last name) but the result is always 1 (it counts instead of displaying the text from these fields)
what am i doing wrong??? please someone help me.
i have attached an image of the calculation problem.