G
Guest
I'm using office 2003. I know it is possible to name a field, then use that
field for a calculation within the same query. I've done it before. I have a
new query, and it isn't working. Can anybody tell me why. Let me give an
example of what I mean:
Say each employee has an average attendance, then an average adherence. They
are then scored on each of those. For example, in Query2:
AttScore: [Query1].[Attendance] * 0.5
AdhScore: [Query1].[Adherence] * 0.5
This would calculate the scores. What I next want to do would be the
following:
TotalScore: AttScore + AdhScore
I've tried it many different ways in case the formatting mattered, such as
the above and:
TotalScore: [AttScore] + [AdhScore]
and:
TotalScore: [Query2].[AttScore] + [Query2].[AdhScore]
Nothing is working. Every time I try to run the query, it asks me to define
the fields, but if I leave the total score out, it works fine (meaning it
isn't a problem with where the fieldnames were defined in the first place)
So, using the above example, I'd get a pop up asking me to enter a value for
AttScore and one for AdhScore. Can anybody tell me what I could be doing
wrong and how I may be able to fix the problem.
--
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy
~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor
field for a calculation within the same query. I've done it before. I have a
new query, and it isn't working. Can anybody tell me why. Let me give an
example of what I mean:
Say each employee has an average attendance, then an average adherence. They
are then scored on each of those. For example, in Query2:
AttScore: [Query1].[Attendance] * 0.5
AdhScore: [Query1].[Adherence] * 0.5
This would calculate the scores. What I next want to do would be the
following:
TotalScore: AttScore + AdhScore
I've tried it many different ways in case the formatting mattered, such as
the above and:
TotalScore: [AttScore] + [AdhScore]
and:
TotalScore: [Query2].[AttScore] + [Query2].[AdhScore]
Nothing is working. Every time I try to run the query, it asks me to define
the fields, but if I leave the total score out, it works fine (meaning it
isn't a problem with where the fieldnames were defined in the first place)
So, using the above example, I'd get a pop up asking me to enter a value for
AttScore and one for AdhScore. Can anybody tell me what I could be doing
wrong and how I may be able to fix the problem.
--
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy
~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor