Populate totals into months

[JBP]

Hello All,
This is my scenario

Jan Feb Mar etc.... Total STart End
100 01/05/2004 09/05/2004

How do I populate 100 from Jan through to September in an
Access Query?

 

[Tim Ferguson]

Jan Feb Mar etc.... Total STart End
100 01/05/2004 09/05/2004

How do I populate 100 from Jan through to September in an
Access Query?

Normalise the data design. Change this to a table that contains one row for
each month, and then display a Group By query with a Sum() to add them up.

HTH


Tim F