查询日期范围< =第2部分

问题描述

嗨


我正在重新发布这个帖子，因为它已经变得非常混乱，我有办法解决这个问题所以这是一个与初始线程略有不同的问题。


这里是最初的花纹




只是为了澄清一下我正在努力实现....


我有一张带有日历预订记录的表格，这些记录已从outlook导入，因此开始日期和结束日期采用以下格式：dd：mm： yyyy hh：nn：ss这就是我认为是问题的根源


我有一个表单，旨在以星期一 - 星期日的格式显示表格中的日历预订所以用户选择一个日期，并在表格上显示整周，例如，如果用户选择9/9/09，表格将显示从7/9/09 - 13/9/09类似于Outlook的工作方式s


我遇到问题的查询旨在获取该表单上的开始和结束日期范围，并在我所拥有的日期范围内返回表格中的所有日历预订现在让我的工作如何我想要它

展开 | 选择 | Wrap | 行号

解决方案

Hi

I am re-posting this thread because it has become very confusing and I have got some way to solving the problem so it is a slightly different question from the initial thread.

here is the original tread

http://bytes.com/topic/access/answer...ery-date-range

Just to clarify what I am trying to achieve....

I have a table with calendar booking records which has been imported from outlook so the start date and end date are in this format dd:mm:yyyy hh:nn:ss this is what I believe is the root of the problem

I have a form that is designed to display the calendar bookings from the table in a monday - sunday format so a user selects a date and on the form the full week is displayed so for example if the user selects 9/9/09 the form will display from the 7/9/09 - 13/9/09 similar to how outlook works

The query that I was having problems with is designed to pick up the start and end date range on that form and return all the calendar bookings from the table within the date range I have now got this to work how I want it to

Expand|Select|Wrap|Line Numbers

解决方案

这篇关于查询日期范围< =第2部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！