[mso] Re: access 2003reports- additional info
- From: "Fitzmaurice, Ann E." <a.e.fitzmaurice@xxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 2 Mar 2008 13:17:03 -0000
hi david and all
thankyou for your email, i will try to elaborate,i have the following
name - ann
hours average rate of pay rate inflator holiday due
20 4.52677777 10,129 answer
where answer = hours * average rate of pay * (rate inflator /100)
this started in october and presently runs to the 24th february,
what i want to do is to show preferably next to the name the date from until
the date to , as although the report i have at present covers the first three
months and therefore having no date is not a problem, for subsequent periods
(normally in roughly three month tranches) it will be a problem
on another report i have to input the start date and finish date before running
the report but cant remember how i did this- you will gather that i do not use
access very often, so each time i do soimething it is a learning experience
i hope that this explanation gives a clearer understanding as to what i am
trying to achieve
thanks
ann
Ann E Fitzmaurice
Medical Statistician
Immpact ,University of Aberdeen
Health Sciences Building
Foresterhill
Aberdeen, AB25 2ZD
Scotland
Tel: +44 (0)1224 553876
Fax: +44 (0)1224 555704
Email: <mailto:a.e.fitzmaurice@xxxxxxxxxx <mailto:a.e.fitzmaurice@xxxxxxxxxx>
> a.e.fitzmaurice@xxxxxxxxxx
________________________________
From: mso-bounce@xxxxxxxxxxxxx on behalf of David Smart
Sent: Sun 02/03/2008 07:03
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: access 2003reports
I don't have a feel for where you're having problems. Assuming the dates
are fields in the database, you'd just select them from the table and
position them in the report in the same ways as any other fields.
What specifically are you having problems with, with dates?
Regards, Dave S
----- Original Message -----
From: "Fitzmaurice, Ann E." <a.e.fitzmaurice@xxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Sunday, March 02, 2008 6:17 AM
Subject: [mso] access 2003reports
> hi
>
> have creared a report with a sperate section for each person
>
> for each person the report shows , the sum of the hours worked, the
> average hourly rate, the rate multiplier used to calculate the amount of
> an additiona payment to be made, i have all this working
>
> what i would like to add is the dat from and the date to, but dont know
> how to select and then to show in the report
>
> any help would be great
>
> ann
>
> Ann E Fitzmaurice
> Medical Statistician
> Immpact ,University of Aberdeen
> Health Sciences Building
> Foresterhill
> Aberdeen, AB25 2ZD
> Scotland
>
> Tel: +44 (0)1224 553876
>
> Fax: +44 (0)1224 555704
>
> Email: <mailto:a.e.fitzmaurice@xxxxxxxxxx
> <mailto:a.e.fitzmaurice@xxxxxxxxxx> > a.e.fitzmaurice@xxxxxxxxxx
>
>
>
>
> The University of Aberdeen is a charity registered in Scotland, No
> SC013683.
>
> *************************************************************
> 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
>
> To be able to share files with the group, you must join our Yahoo sister
> group. This group will not allow for posting of emails, but will allow
> you to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE SHARING ONLY.
>
> 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
> *************************************************************
*************************************************************
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
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
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
*************************************************************
The University of Aberdeen is a charity registered in Scotland, No SC013683.
-- No attachments (even text) are allowed --
-- Type: application/ms-tnef
-- File: winmail.dat
*************************************************************
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
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
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:
