Grouping bug/Anomoly?

[djfuego]

I'm having a grouping issues whereby the Job Date header appears to be duplicating randomly in a list. Anyone expirenced this before?





Eg:

Jobname
Job date Sum Paid
2/3/2011 £30
Job date Sum Paid
4/6/2011 £30
5/6/2011 £30
8/6/2011 £30

It Should Look like

Jobname
Job date Sum Paid
2/3/2011 £30
4/6/2011 £30
5/6/2011 £30
8/6/2011 £30

[pbaldy]

I would suspect something in the data. Can you post the db here?

[djfuego]

I can't post the DB. A little more testing and even though I take out the offending data and then try to add it in as a new entry the same thing happens.
Hold on.. D'oh!!!!
In the report grouping options at the bottom of the design view I must have inadvertently selected Quarterly. I set to Yearly and the problem is solved.
User error.. MEH

[pbaldy]

Happens to us all!