Hello,
I have a report that I am trying to create in my database. The database is based off of the "Contacts" sample database that Access provides and I have made modifications to it.
Here is my problem. In my 'contacts' table I have all of the contacts ordered the way I like them (See the first image below). The image below shows my table with a subset of names of individuals that work for a branch called "biorepositories" which are highlighted. I generated a query to pull specific information form the table that I wanted in the report (even here the contact names are ordered correctly when I run the query). I generated a report (it is a web compatible report it that helps to solve the problem) and added a "Group" for the contacts based on the branch that they work for. However, if you take a look at the contact names in the second image you will see that two of the names are out of order. Helen should be the first name listed, but instead Abhi is the first name listed. Also Deborah should be the last name in the group but Latarsha is listed as the last name.
How do I get these names to appear correctly on my report? What is causing these couple of names to suddenly change order without direction? Any help would be great.
![]()