问题描述
嘿......我有一份报告，其详细部分基于三个部门，所以报告是3页，加上两页报告页脚和
封面页面报告标题。如果三个部门是a，b和c，我可以按升序或降序打印。但是，我会像b-a-c一样模仿excel电子表格这是一个副本
。在我把它们装订之前重新安排论文并不是什么大不了的事，但是当我每季度运行大约20-30份时，它将是
更容易让它按顺序出来。有什么方法可以让我的报告到
选择一个特定的订单？谢谢。
-
Greg
通过AccessMonster.com发布消息
-
Greg
通过AccessMonster.com发布消息
来自AccessMonster.com的
我猜一种方法可以尝试切换功能 - 空气代码 - 请查看
帮助文件中的功能以获取更多信息，或者回复
select< field list>，
开关（[MyDep] =" A"，2，[MyDep] =" B"，1，[MyDep] =" C"，3）as MyOrderBy
来自< yourtables> ;
其中< conditions>
按开关排序（[MyDep] =" A"，2，[MyDep] =" B"，1，[MyDep ] =" C"，3）
-
Roy-Vidar
hey... i have a report whose detail section is based on three departments so
the report is 3 pages for that, plus two pages for a report footer and a
cover page report header. if the three departments are a, b and c, i can get
them to print either in ascending or decending order. however, i would
really like it to be b-a-c to mimic the excel spreadsheet this was a copy
from originally. it''s not THAT big a deal to rearrange the papers before i
staple them, but when i run off about 20-30 copies each quarter, it would be
easier to have it come out in order. is there any way i can get my report to
select a specific order? thanks.
--
Greg
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
--
Greg
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
I guess one way could be trying the switch function - "air code" - look
up the function in the help files for more info, or post back
select <field list>,
switch([MyDep]="A",2,[MyDep]="B",1,[MyDep]="C",3) as MyOrderBy
from <yourtables>
where <conditions>
Order By switch([MyDep]="A",2,[MyDep]="B",1,[MyDep]="C",3)
--
Roy-Vidar
这篇关于非常规的报告令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！