select by month on a form

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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.
 
Please investigate the DATEPART function. Note also that you can group
on a "date part".

Good Luck!
 
That got me in the right direction
--
Many Thanks
Kevin


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

Good Luck!
 
Back
Top