report not grouping correctly

[stephendeloach via AccessMonster.com]

i set up a report with grouping on Repair, Employee. My Employee isnt
grouping right. Say the employee name is Stephen, it will group half of
everything with Stephen, then another half with Stephen... I have looked at
the form to make sure it is entered correctly and it is.. I cant figure it
out? Thanks

 

[KARL DEWEY]

I do not understand. It seems like it is grouping like it is suppose to as
Stephen,
is not the same as
Stephen...
and would be another group.

Am I missing something or reading what you wrote incorrectly?

Try grouping like this --
Replace(Replace([YourField], ".",""), ",", "")

This will ignore commas and periods.

 

[stephendeloach via AccessMonster.com]

Sorry, I didnt write it correctly. There is only one entry, Stephen with no
commas or periods. But they arent grouped together? Thanks

I do not understand. It seems like it is grouping like it is suppose to as
Stephen,
is not the same as
Stephen...
and would be another group.

Am I missing something or reading what you wrote incorrectly?

Try grouping like this --
Replace(Replace([YourField], ".",""), ",", "")

This will ignore commas and periods.

i set up a report with grouping on Repair, Employee. My Employee isnt
grouping right. Say the employee name is Stephen, it will group half of
everything with Stephen, then another half with Stephen... I have looked at
the form to make sure it is entered correctly and it is.. I cant figure it
out? Thanks

 

[stephendeloach via AccessMonster.com]

I went back and re-entered the fields and it works now? I dont know why but
it works. Thanks

I do not understand. It seems like it is grouping like it is suppose to as
Stephen,
is not the same as
Stephen...
and would be another group.

Am I missing something or reading what you wrote incorrectly?

Try grouping like this --
Replace(Replace([YourField], ".",""), ",", "")

This will ignore commas and periods.

i set up a report with grouping on Repair, Employee. My Employee isnt
grouping right. Say the employee name is Stephen, it will group half of
everything with Stephen, then another half with Stephen... I have looked at
the form to make sure it is entered correctly and it is.. I cant figure it
out? Thanks