Populate totals into months

  • Thread starter Thread starter JBP
  • Start date Start date
J

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?
 
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?
Click to expand...

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
 
Back
Top