在MS Access 2000报告中设置排序顺序 [英] Set sort order in MS Access 2000 report

问题描述

你好，


我有一个报告，优先级字段用作排序顺序和

分组。问题是此优先级字段中的数据如果按照
升序排序为：高，低和中。我怎么能把它分类为：

低，中，高？


任何建议都非常感谢，

James

Hello,

I have a report with the Priority field is used as sort order and
grouping. The problem is the data in this Priority field if sorted in
ascending order is: High, Low, and Medium. How could I sort it as:
Low, Medium, High?

Any suggestion is greatly appreciated,
James

推荐答案

詹姆斯，你不知道怎么做，但你能做的是将报告基于

查询。在查询中添加您想要的报表字段，然后将

以下语句添加到查询网格中空列的顶行（字段:)

txtSort：

IIf（[Priority] =" Low"，1，IIf（[Priority] =" Medium"，2，IIf（[Priority] =" High"，3）））


现在您可以在查询中通过此字段进行排序，也可以通过报告中的排序和

分组进行排序。


希望这会有所帮助！


Reggie


----------

" ; James P. <公顷********* @ yahoo.com>在留言中写道

news：f4 ************************** @ posting.google.c om ...

James, Don''t know how you can, but what you could do is base the report on a
query. In the query add the fields you want for your report then add the
below statement to the top row (Field:) of an empty column in you query grid
txtSort:
IIf([Priority]="Low",1,IIf([Priority]="Medium",2,IIf([Priority]="High",3)))

Now you can sort by this field either in the query or via the sorting and
grouping in the report.

Hope this helps!

Reggie

----------
"James P." <ha*********@yahoo.com> wrote in message
news:f4**************************@posting.google.c om...

您好，

我有一个报告，优先级字段用作排序顺序和
分组。问题是此优先级字段中的数据如果按升序排序为：高，低和中。我怎么能把它分类为：
低，中，高？

任何建议都非常感谢，詹姆斯

Hello,

I have a report with the Priority field is used as sort order and
grouping. The problem is the data in this Priority field if sorted in
ascending order is: High, Low, and Medium. How could I sort it as:
Low, Medium, High?

Any suggestion is greatly appreciated,
James

" James P." <公顷********* @ yahoo.com>在消息中写道

news：f4 ************************** @ posting.google.c om

"James P." <ha*********@yahoo.com> wrote in message
news:f4**************************@posting.google.c om

您好，

我有一个报告，优先级字段用作排序顺序和
分组。问题是此优先级字段中的数据如果按升序排序为：高，低和中。我怎么能把它分类为：
低，中，高？

任何建议都非常感谢，詹姆斯

Hello,

I have a report with the Priority field is used as sort order and
grouping. The problem is the data in this Priority field if sorted in
ascending order is: High, Low, and Medium. How could I sort it as:
Low, Medium, High?

Any suggestion is greatly appreciated,
James

您正按文本字段排序。最好使用数字代码来表示

级别的查找表来获取文本，使得排序更容易

更容易。


例如。

1高

2中等

3低

-

问候，


布拉德利

You are sorting by a text field. Best to use a numeric code to represent
the levels with a lookup table to get the text, makes sorting much
easier.

eg.
1 High
2 Medium
3 Low
--
regards,

Bradley

" Reggie" < NoSpam_webmaster@NoSpam_smittysinet.com>在留言新闻中写道：< i6 ******************** @ comcast.com> ...

"Reggie" <NoSpam_webmaster@NoSpam_smittysinet.com> wrote in message news:<i6********************@comcast.com>...

詹姆斯，不要知道你怎么做，但你可以做的是将报告基于
查询。在查询中添加您想要的报表字段，然后将
下面的语句添加到查询网格中空列的顶行（Field :)
txtSort：
IIf（[Priority] ] =低，1，IIf（[优先级] =中等，2，IIf（[优先级] =高，3）））

现在您可以按这个字段要么在查询中，要么通过报告中的排序和分组。

希望这会有所帮助！

Reggie

- ---------
James P. <公顷********* @ yahoo.com>在消息中写道
新闻：f4 ************************** @ posting.google.c om ...

James, Don''t know how you can, but what you could do is base the report on a
query. In the query add the fields you want for your report then add the
below statement to the top row (Field:) of an empty column in you query grid
txtSort:
IIf([Priority]="Low",1,IIf([Priority]="Medium",2,IIf([Priority]="High",3)))

Now you can sort by this field either in the query or via the sorting and
grouping in the report.

Hope this helps!

Reggie

----------
"James P." <ha*********@yahoo.com> wrote in message
news:f4**************************@posting.google.c om...

您好，

我有一个报告，优先级字段用作排序顺序和
分组。问题是此优先级字段中的数据如果按升序排序为：高，低和中。我怎么能把它分类为：
低，中，高？

任何建议都非常感谢，詹姆斯

Hello,

I have a report with the Priority field is used as sort order and
grouping. The problem is the data in this Priority field if sorted in
ascending order is: High, Low, and Medium. How could I sort it as:
Low, Medium, High?

Any suggestion is greatly appreciated,
James

谢谢Reggie。

Thank you, Reggie.

这篇关于在MS Access 2000报告中设置排序顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！