执行交叉表查询 - 仅需要当前周的1个字段的信息 [英] Doing crosstab query - need info from current week only for 1 field
问题描述
我的雇主每周跟踪临床医生的生产率/表现（他们每周花费多少b
$ b），这个月的平均值和6个月。
这些平均值与他们的预期生产率进行比较。
然而，预期会发生变化 - 暂时可能会有60％，那么
改为
50％。最初，我平均期望值和
的生产率，但我要问的是，与期望值相比，我们要考虑的是平均生产率/性能。对于当前
周
（不是几周的平均值）。
我做一个交叉表来查看所有这些并且我不确定如何判断
访问
仅查看当前周的预期与平均
表现相比。
例如 - 我的字段是Week of本周将是4/17/06最后一周
周和
4/24/06。我还有一个名为Expectation的字段。
可能
上周为50％，但本周为55％。当我运行
交叉表时，我的实际表现平均值，但只想看看本周预期（55％）的
。我不想平均值为
50％和55％。
这是否有意义并且任何人都可以提供帮助吗？
谢谢 -
Tina
Tina写道：< blockquote class =post_quotes>我的雇主每周追踪临床医生的生产率/表现（他们每周收费多少），月平均值和6个月。
这些平均值是与他们预期的生产力相比。
但是，期望会发生变化 - 一段时间可能会有60％的变化，然后会变为50％。最初，我的平均预期和生产力平均值，但我要问的是，与当前的CURRENT周相比，我们要考虑的是平均生产率/性能。
（不是几个星期的平均值）。
我做一个交叉表来查看所有这些并且我不确定如何告诉
访问
只查看CURRENT周的预期与平均表现相比。
例如 - 我的字段是周。这将是本周最后一周的4/17/06和本周的4/24/06。我还有一个名为Expectation的字段。上周可能已经达到了50％，但本周这个比例为55％。当我运行
交叉表时，我的实际表现是平均的，但只想看看本周的预期（55％）。我不想平均得分50％和55％。
这有意义吗？任何人都可以帮忙吗？
Tina，
请显示几个带有字段名的数据样本行以及
样本计算。我有信心有人在这里可以帮助我们了解你想要做什么。
谢谢，
James A. Fortune
CD********@FortuneJames.com
尝试使用多维数组来读取数据。
首先，捕获期望值= current（你可以使用
**格式（Now（），" ww"）**来获取周数）。然后从交叉表中拉出
期望数据，或者将
交叉表中的数据写入多维数组。您应该可以通过一个简单的查询将两个数据结合起来，或者将它们一起写入
数组。
Dig？
http://www.eyesoft.net
CD *** *****@FortuneJames.com 写道：
Tina写道：我的雇主追踪临床医生的生产力/表现（多少<他们每周都会记录这个月的平均值，以及6个月的平均值。
将这些平均值与预期的生产率进行比较。
然而，期望会发生变化 - 一段时间可能是60％，然后改为
50％。最初，我的平均预期和生产力平均值，但我要问的是，与当前的CURRENT周相比，我们要考虑的是平均生产率/性能。
（不是几个星期的平均值）。
我做一个交叉表来查看所有这些并且我不确定如何告诉
访问
只查看CURRENT周的预期与平均表现相比。
例如 - 我的字段是周。这将是本周最后一周的4/17/06和本周的4/24/06。我还有一个名为Expectation的字段。上周可能已经达到了50％，但本周这个比例为55％。当我运行
交叉表时，我的实际表现是平均的，但只想看看本周的预期（55％）。我不想平均分50％和55％。
这是否有意义，任何人都可以帮忙吗？
蒂娜，
请显示一些带有字段名的数据样本行以及
样本计算。我相信这里有人可以帮助我们理解你要做的事情。
谢谢，
詹姆斯A.财富
CD ******** @ FortuneJames.com
这里来自交叉表数据表的数据行。在交叉表中，我的
行是LName，FName，Ave Expection和Director。我的月份是
列标题。我每个月的平均生产率是价值。
我不知道这是否有意义..抱歉..
LASTNAME FIRSTNAME Avg期望总监
ANDERSON KARON 50.00％
Dave Shiel
九月，05十月，05
38.00％39.33％
My employer tracks productivity/performance of clinicians (how much
they
bill) each week, its averages for the month, and the 6 months.
These averages are compared to their expected productivity.
However, the expectation changes - it may be 60% for a while, then
change to
50%. Initially, I was averaging the expectation, along with the
productivity, but what I''m being asked is to look at the average
productivity/performance compared to the expectation for the CURRENT
week
(not the average across weeks).
I do a crosstab to look at all of this and am not sure how to tell
Access to
look only the CURRENT week''s expectation compared to average
performance.
For example -- my field is "Week of" which would be 4/17/06 for last
week and
4/24/06 for this week. I have another field called "Expectation" which
may
have been 50% last week, but it 55% this week. When I run the
crosstab, I''m averaging the actual performance but only want to look
at the expectation (the 55%) for this week. I don''t want to average
the 50% and 55%.
Does this make sense and can anyone help?
Thanks -
Tina
Tina wrote:My employer tracks productivity/performance of clinicians (how much
they
bill) each week, its averages for the month, and the 6 months.
These averages are compared to their expected productivity.
However, the expectation changes - it may be 60% for a while, then
change to
50%. Initially, I was averaging the expectation, along with the
productivity, but what I''m being asked is to look at the average
productivity/performance compared to the expectation for the CURRENT
week
(not the average across weeks).
I do a crosstab to look at all of this and am not sure how to tell
Access to
look only the CURRENT week''s expectation compared to average
performance.
For example -- my field is "Week of" which would be 4/17/06 for last
week and
4/24/06 for this week. I have another field called "Expectation" which
may
have been 50% last week, but it 55% this week. When I run the
crosstab, I''m averaging the actual performance but only want to look
at the expectation (the 55%) for this week. I don''t want to average
the 50% and 55%.
Does this make sense and can anyone help?
Tina,
Please show a few sample lines of data with fieldnames along with a
sample calculation. I feel confident that someone here can help once
we understand what you are trying to do.
Thanks,
James A. Fortune
CD********@FortuneJames.com
Try using a multi-dimensional array to read the data in.
First, capture Expectation where week = current (you can use
**Format(Now(), "ww")** to get the week number). Then pull the
expectation data out of your crosstab, or write the data from your
crosstab into a multi-dimensional array. You should be able to marry
the two pieces of data with a simple query, or write them together into
an array.
Dig?
http://www.eyesoft.net
CD********@FortuneJames.com wrote:
Tina wrote:My employer tracks productivity/performance of clinicians (how much
they
bill) each week, its averages for the month, and the 6 months.
These averages are compared to their expected productivity.
However, the expectation changes - it may be 60% for a while, then
change to
50%. Initially, I was averaging the expectation, along with the
productivity, but what I''m being asked is to look at the average
productivity/performance compared to the expectation for the CURRENT
week
(not the average across weeks).
I do a crosstab to look at all of this and am not sure how to tell
Access to
look only the CURRENT week''s expectation compared to average
performance.
For example -- my field is "Week of" which would be 4/17/06 for last
week and
4/24/06 for this week. I have another field called "Expectation" which
may
have been 50% last week, but it 55% this week. When I run the
crosstab, I''m averaging the actual performance but only want to look
at the expectation (the 55%) for this week. I don''t want to average
the 50% and 55%.
Does this make sense and can anyone help?
Tina,
Please show a few sample lines of data with fieldnames along with a
sample calculation. I feel confident that someone here can help once
we understand what you are trying to do.
Thanks,
James A. Fortune
CD********@FortuneJames.com
Here''s line of data from the cross tab datasheet. In the cross tab, my
rows are LName, FName, Ave Expection, and Director. My month is the
column heading. My productivity averaged for each month is the value.
I don''t know if this is making any sense or not.. sorry..
LASTNAME FIRSTNAME Avg Expectation Director
ANDERSON KARON 50.00%
Dave Shiel
September, 05 October, 05
38.00% 39.33%
这篇关于执行交叉表查询 - 仅需要当前周的1个字段的信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
