i'm building a database to manage data that is updated daily. data will be viewed monthly though, summed and averaged that is. i used 1 table to store all the data. but then, on the form to view the data, i am clueless. in the table, the field 'date' used access standard 'date&time' mask. can a query access the month and year from that field? how to implement it to the form so that only data on specific month is viewed? many thanx in advance... 
