Report based on name query groups first names together

[Guest]

I have a report based on a query where the user enters first name (partial) ,
last name (partial) and date of birth parameters (ie, Jef, Blu, 05/21/1971).
From the table, the query pulls the following records:

Jeff Blume 05/21/1971
Jeffery Blue 05/21/1971
Jefferson Blue 05/21/1971
Jeffery Blume 05/21/1971

My problem is the report based on this query lists all 'Jef' 'Blume' records
under 'Jeff Blume' and all 'Jef' 'Blue' records under 'Jeffery Blue'. So
essentially, the records for Jeffery Blume and Jefferson Blue are listed
under the other wrong names. Any ideas? Any help is greatly appreciated!
Thanks!

 

[Guest]

Can you post your SQL?

 

[Douglas J. Steele]

Do you have the first and last names stored in separate fields? If so, how
are you sorting the report. If not, then you may have some rework on your
hands...

 

[Guest]

They are in separate fields.

Could it have to do with where they are located on the report? Then name
fields are under 'Name Header'. Part of the related record info, that seems
to be working fine, is under two other headers but nothing is under the
'Detail Header'. Does that matter? I started with a wizard but I couldn't get
it to do exactly what I needed so I improvised.

 

[Douglas J. Steele]

What have you put in the Sorting and Grouping dialog? With reports, that's
the only thing that controls the order in which records are displayed: any
sorting that may have been applied in the underlying recordsource is
ignored.

 

[Guest]

Well I thought I fixed it because I didn't have the first name field in the
Sorting and Grouping but now that I have added it my report still lists 'Jeff
Blu' info under 'Jef Blu'. I have info for both a Jeff Blu and Jef Blu but it
only shows the header for Jef and both listings are under that.

In Sorting and Grouping I list the Last Name field first then the First Name
field. I have both fields marked:

Group Header: Yes
Group Footer: No
Group On: Each Value
Keep Together: No

I don't quite get what those mean.

Kristine

 

[Douglas J Steele]

Where in the report do you have the First Name and Last Name displaying? Is
it in the GroupHeader associated with the fields, or is it in the Details
section?

 

[Guest]

Actually I have that all goofed up. The First Name field I moved up into the
Last Name header (I forgot all this until you asked, sorry) because I want
them next to each other in the report. I have totally different info in the
First Name header. It was all working great until I noticed this glitch with
the names. Oops!

Kristine

 

[Douglas J. Steele]

You may have to put both names in the First Name section, not the Last Name
section.