report not grouping correctly

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

--
Message posted via http://www.accessmonster.com

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.
--
KARL DEWEY
Build a little - Test a little


"stephendeloach via AccessMonster.com" wrote:

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

--
Message posted via http://www.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

KARL DEWEY wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200708/1

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

KARL DEWEY wrote:
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200708/1