Unanswered: Update query using results from a function
Hello. Trying to do an Access Update Query that will update a table with the results of a function. I am new to doing functions, so I am not sure at which point I have a problem here.
This is the problem. The db software my company runs keeps Contact Information on customers in only one field, it doesn't split them into FirstName and LastName. It does have fields for FirstName and LastName but they always remain empty, so for the purposes of a report I need to do I am trying to split up the ContactName field.
I have written two functions.
Public Function FirstName()
Public Function LastName()
My thinking is that I need a First Name and a Last Name to call them each individually.
In the query itself I call the function by putting [FirstName] or [LastName] into the update to column. When I change to view mode I can see that it does indeed split them apart, but when I run the query it only seems to work for some records and ignores others.