做双重查询的最佳方法？ [英] best way of doing a double query?

问题描述

我有一个查询，它提取特定事件的信息，并将所有其他信息拉成一个表格发送给客户确认。一切正常。


然后我遇到了一个问题，其中一些事件可以运行超过2天或更多天，但不想每天为它们提供多张表。什么是最好的方法来进行查询，然后从第1天和第2天拉出数据？


我不能考虑如何做到这一点？或者最好的方法是什么......等等......任何想法？

解决方案

缺乏信息，但您是否考虑按日期对报告进行分组？ br />

Phil

目前报告的查询来自表格中打开的事件。

展开 | 选择 | Wrap | 行号

假设事件包含FromDate和ToDate然后尝试分组ToDate


Phil

i have a query which pulls the information for specific event, and pulls all the other information into one form to send to client to confirm. which all works fine.

But then I came across a problem where some events can run over 2 or more days, but dont want to give them multiple sheets for each day. What is there best way to do a query and then pull the data from day1 and then day2?

i cant think around how to do it? or what the best way of doing it would be etc... any thoughts?

解决方案

Tad short of information, but haven you considered grouping your report by date?

Phil

Currently the query for the report goes from which event is open in the form.

Expand|Select|Wrap|Line Numbers

Assuming the event contains a FromDate and a ToDate then try grouping on the ToDate

Phil

这篇关于做双重查询的最佳方法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！