[mso] Re: access 2003reports
- From: "Fitzmaurice, Ann E." <a.e.fitzmaurice@xxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 4 Mar 2008 11:34:56 -0000
Thanks to all who have given suggestions re using dates to and from in
the access report, it looks like I will need to redo the report as I had
it based directly on a table and not on a query, will do the query and
redo the report
Thanks for all the help, very useful as usual
Ann
Ann E Fitzmaurice
Medical Statistician
Immpact
University of Aberdeen
Health Sciences Building
Foresterhill
Aberdeen, AB25 2ZD
Scotland, United Kingdom
=20
Tel: +44 (0)1224 553876
Fax: +44 (0)1224 555704
Email: a.e.fitzmaurice@xxxxxxxxxx
url: http//www.immpact-international.org/
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Jim Pettit
Sent: 04 March 2008 11:14
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: access 2003reports
Cathy's method will work very well, and is, in fact, the 'preferred'
method,
but to be even quicker about it, by avoiding the need to call a separate
form, you could do the following:
1) Open the Query Designer on the query underlying the data source used
for
the report
2) Enter the following in the column containing the date field on which
you'd like to limit your results:
Between [Enter Start Date] And [Enter End Date]
3) In the report header, create a text box
4) Give that text box the following for its Control Source:
=3D"Employee hours from " & [Enter Start Date] & " to " & [Enter =
End
Date]
When the report is run, the user will see two simple text boxes, the
first
asking for the start date and the second asking for the end date. Once
the
report is compiled, the report header will show whatever dates were
entered,
i.e.:
Employee hours from 10/1/2007 to 12/31/2007
Hope this helps
--Jim
"Fitzmaurice, Ann E." <a.e.fitzmaurice@xxxxxxxxxx>
Sent by: mso-bounce@xxxxxxxxxxxxx
03/01/2008 02:17 PM
Please respond to mso
To
<mso@xxxxxxxxxxxxx>
cc
Subject
[mso] access 2003reports
hi
=20
have creared a report with a sperate section for each person
=20
for each person the report shows , the sum of the hours worked, the=20
average hourly rate, the rate multiplier used to calculate the amount of
an additiona payment to be made, i have all this working
=20
what i would like to add is the dat from and the date to, but dont know=20
how to select and then to show in the report
=20
any help would be great
=20
ann
=20
Ann E Fitzmaurice
Medical Statistician
Immpact ,University of Aberdeen
Health Sciences Building
Foresterhill
Aberdeen, AB25 2ZD
Scotland
Tel: +44 (0)1224 553876=20
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=20
SC013683.
=20
No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.516 / Virus Database: 269.21.4/1309 - Release Date:
3/3/2008
6:50 PM
=20
*************************************************************
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.
*************************************************************
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:
