Full Name in reverse order in the combo box when browsing

[Frank Situmorang]

Hello,

I have the church officers table to fill by form.
On the Name of the officers field in the form is using combo whch row source
is from calculated field of a church member query.

My question is how can we make this calculated fieldL
FullName: [FNAME] & " " & [MNAME] & " " & [LNAME]
when we browse in combo looks in a reverse order, meaning starting with
lastname, middle, first, while in the table form actually it should be in the
normal full name, starting with First Name.

We need your help and thanks very much.

 

[John W. Vinson]

Hello,

I have the church officers table to fill by form.
On the Name of the officers field in the form is using combo whch row source
is from calculated field of a church member query.

My question is how can we make this calculated fieldL
FullName: [FNAME] & " " & [MNAME] & " " & [LNAME]
when we browse in combo looks in a reverse order, meaning starting with
lastname, middle, first, while in the table form actually it should be in the
normal full name, starting with First Name.

We need your help and thanks very much.

The Query upon which the combo is based should sort the records in whatever
order you want. If you want it sorted by firstname, sort by firstname.

You don't describe your table structure, but you could try a query like

SELECT PersonID, [FNAME] & (" " + [MNAME]) & " " & [LNAME] AS FullName
FROM peopletable
ORDER BY FNAME, MNAME, LNAME;

 

[Frank Situmorang]

Thanks John for your quick response. May be I need to explain more about my
problem, It works now to fill the fullname in the church officers table, but
what I want is when we click the combo I want it shows by last name first to
facilitate brwsing. In fact the data to be put is fullname ( calculated
field) starting with First, Middle and LastName.

Do you have any idea?

--
H. Frank Situmorang

Hello,

I have the church officers table to fill by form.
On the Name of the officers field in the form is using combo whch row source
is from calculated field of a church member query.

My question is how can we make this calculated fieldL
FullName: [FNAME] & " " & [MNAME] & " " & [LNAME]
when we browse in combo looks in a reverse order, meaning starting with
lastname, middle, first, while in the table form actually it should be in the
normal full name, starting with First Name.

We need your help and thanks very much.

The Query upon which the combo is based should sort the records in whatever
order you want. If you want it sorted by firstname, sort by firstname.

You don't describe your table structure, but you could try a query like

SELECT PersonID, [FNAME] & (" " + [MNAME]) & " " & [LNAME] AS FullName
FROM peopletable
ORDER BY FNAME, MNAME, LNAME;

 

[John W. Vinson]

Thanks John for your quick response. May be I need to explain more about my
problem, It works now to fill the fullname in the church officers table,

The Church Officers table should NOT contain ANYBODY'S name.

An officer is a person. You should have a people (members) table; the name
should exist in that table, and ONLY in that table. The members table should
have a memberID; only that ID should be stored in the Officers table. When you
want to see the officer's name, you would use a query joining the Officers
table to the People table by person ID.

but
what I want is when we click the combo I want it shows by last name first to
facilitate brwsing. In fact the data to be put is fullname ( calculated
field) starting with First, Middle and LastName.

It would be a serious mistake to do so.