select by month on a form

[Kevin]

Hi Guys, i have a form that displays data from 2 sub-forms, the firts is
laborsubform and the second is matreials subform. In both bubforms i have a
date field when the date is entered, What i would like displayed is for each
month the labor entered and the materials entered, then another area that
shows the yea to date and the then also last year. I can select all the
toatals easily, but i can't break it down into months and years.

Secondaly i woul like to be able to select the data that has in invoice
number in a filed called invoicenumber.

If anyone can point me in the right direction, it would be greatly
appreciated.

 

[rm]

Please investigate the DATEPART function. Note also that you can group
on a "date part".

Good Luck!

 

[Kevin]

That got me in the right direction
--
Many Thanks
Kevin

Please investigate the DATEPART function. Note also that you can group
on a "date part".

Good Luck!