We have an access table of about 800 records. The field containing the names of the participants is (First Name + Space + Last Name), I need to change them to (Last Name + Comma + space + First Name). This needs to be done only once to correct the current database because we will be using a combo box with the names in alphabetical order by last name for all future inputs. Future names will be taken from a new table which will be in the correct order.
How can I let the computer reverse the order of the names and automatically place a "comma" and space between the last and first name for each record?
Where would the command be placed? We are using MS Access version 7 in Windows.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query: