How would I do I group my records into one record for each month?
SELECT Montly_Rpt_Table.REPID, Montly_Rpt_Table.Rep, Montly_Rpt_Table.MonthAbb, Montly_Rpt_Table.LostAmt, Montly_Rpt_Table.WonAmt
FROM Montly_Rpt_Table
WHERE (((Montly_Rpt_Table.REPID)=2));
REPID REP MonthAbb LostAmt WonAmt
2 MIKE JAN $15,000
2 MIKE JAN $7,000
2 MIKE FEB $1,500
2 MIKE FEB &1,200
SELECT Montly_Rpt_Table.REPID, Montly_Rpt_Table.Rep, Montly_Rpt_Table.MonthAbb, Montly_Rpt_Table.LostAmt, Montly_Rpt_Table.WonAmt
FROM Montly_Rpt_Table
WHERE (((Montly_Rpt_Table.REPID)=2));
REPID REP MonthAbb LostAmt WonAmt
2 MIKE JAN $15,000
2 MIKE JAN $7,000
2 MIKE FEB $1,500
2 MIKE FEB &1,200