Hi I am new to access and trying to set up a simple data base an associated queries and wonder if any one has sample of the following Fields in table, employee id, employee name, date , hour , rate and a calculated field hours by rate, the format of the hours , rate and total should have 2 dp The queries that I want are to 1 to produce an overall list by employee for the month, sub totals for each employee and overall total 2 to produce separate lists for each employee of the hours worked (itemised by each shift) and total for the month I am struggling how to do this, and have looked how to enter with two dp, the entry keeps reverting to a number Any pointers / examples ann Ann E Fitzmaurice ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************