[mso] Re: access 2003reports- additional info
- From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 3 Mar 2008 07:37:14 +1100
Well, you can put a value request into a query so that it will ask for the
item you want and then use it in, or return it with, the query. The syntax
in the query is the prompt enclosed in square brackets. E.g. [Date from].
That will ask you for the value each time you run the query which will be
called by the report. (If you're not currently using a query, you will need
one, I don't think you can define this straight into a report.
But, it doesn't make a lot of sense, as you describe it. Putting dates
you've typed next to names and values you've extracted from the database
seems to be missing a step somehow. How do you know / ensure that the
information you are displaying from the database is actually associated with
the dates you've typed in?
I think you need to work through the logic of your report much more
carefully before you create it. If the database doesn't have dates in it
already, you probably don't want to start introducing them at report time.
If it does have dates in it already, then you should be using, or checking,
them.
Regards, Dave S
----- Original Message -----
From: "Fitzmaurice, Ann E." <a.e.fitzmaurice@xxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Monday, March 03, 2008 12:17 AM
Subject: [mso] Re: access 2003reports- additional info
> 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
> *************************************************************
*************************************************************
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:
