Iif查询 [英] Iif query

问题描述

大家好


尝试使用Iif编写查询声明。


我创建的数据库是用于美发沙龙预约管理。


问题是，造型师可以在给定的插槽中预订多个客户端。例如，10：00-11：00，他们有客户A。 10:30 - 11:00他们有客户B。


我想写一个查询，如果他们要预订另一个客户 - 它会标记并说另一个预约已被预订。


我无法弄清楚如何做到这一点，因为我将引用同样的事情


如果[StartTime]介于（[StartTime]和[EndTime] - 另一个记录之间）那么......



能帮忙吗？




非常感谢


Dan

Hi All

Trying to write a query using an "Iif" statement.

The database I am creating is for hair salon appointment managment.

The thing is, stylists can book more than one client in a given slot. Eg 10:00 - 11:00 they have Client "A" and 10:30 - 11:00 they have Client "B".

I would like to write a query where if they were to book another client in - it would flag and say another appointment has been booked.

I cant figure out how to do this because I will be refering to the "same thing"

If [StartTime] is between ([StartTime] AND [EndTime] - of another record) Then ......


Can you please help??



Many Thanks


Dan

推荐答案

丹。


你最好澄清你的问题。

你想找到时间间隔与给定时间重叠的记录吗？间隔（即验证创建的新记录）？这很简单。

或者你想找到时间间隔重叠的现有记录？

这个案例尝试运行这样的smthng：

Hi, Dan.

You''d better clarify your question.
Do you want to find a records where time interval overlaps given time interval (i.e. to validate new record created)? This is rather simple.
Or you want to find an existing records where time interval overlaps?
This case try to run smthng like this:

展开 | 选择 | Wrap | 行号

丹。


你'最好澄清一下你的问题。

你想找到时间间隔与给定时间间隔重叠的记录（即验证创建的新记录）吗？这很简单。

或者你想找到时间间隔重叠的现有记录？

这个案例尝试运行这样的smthng：

Hi, Dan.

You''d better clarify your question.
Do you want to find a records where time interval overlaps given time interval (i.e. to validate new record created)? This is rather simple.
Or you want to find an existing records where time interval overlaps?
This case try to run smthng like this:

展开 | 选择 | Wrap | 行号

Dan。这种方式很清楚。


尝试以下查询。它检索重叠的时隙记录。

Hi, Dan. This way quite clear.

Try the following query. It retrieves overlapping time slot records.

展开 | 选择 | Wrap | 行号

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