[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).
http://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
*************************************************************
- References:
- [mso] MS Access
- From: Aerial Photography Directory
- [mso] Re: MS Access
- From: Cathy . Evans
Other related posts:
- » [mso] mso access new user
- [mso] MS Access
- From: Aerial Photography Directory
- [mso] Re: MS Access
- From: Cathy . Evans