[mso] mso access new user

  • From: "Ann E Fitzmaurice" <a.e.fitzmaurice@xxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Wed, 7 Feb 2007 23:55:30 -0000

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
*************************************************************

Other related posts:

  • » [mso] mso access new user