how to show people who don't fall in a time window....??

RIght now I have a query that will show anyone who is on leave durring a certin "start date" and "end date" but now I want to show everyone who is not on leave durring that time. some of them will have dates that don't fall in the start stop window, and some wont even have dates listed.... heres the code I'm working with right now. Thanks to another post I managed to get this code with everyones help, hopefully we can get me this code too! thanks...

Expand|Select|Wrap|Line Numbers

  [StartDate]<=Form_frmReports!txtDateTo

AND [EndDate]>=Form_frmReports!txtDateFrom

Mar 7 '07 #1

Subscribe Post Reply

1090

ADezii

8,834

Expert 8TB

RIght now I have a query that will show anyone who is on leave durring a certin "start date" and "end date" but now I want to show everyone who is not on leave durring that time. some of them will have dates that don't fall in the start stop window, and some wont even have dates listed.... heres the code I'm working with right now. Thanks to another post I managed to get this code with everyones help, hopefully we can get me this code too! thanks...

Expand|Select|Wrap|Line Numbers

[StartDate]<=Form_frmReports!txtDateTo

AND [EndDate]>=Form_frmReports!txtDateFrom

There are other factors to consider:
__1 Suppose either txtDateFrom or txtDateTo or both are Null (missing value(s))?
__2 Suppose non-Date values are entered into this/these Fields?
__3 <= and >= imply inclusion, so the SQL could return a value within the Range when it shouldn't.
__4 Shouldn't the SQL be?

Expand|Select|Wrap|Line Numbers

 'Dates falling outside the Window

[StartDate] < Form_frmReports!txtDateFrom AND [EndDate] > Form_frmReports!txtDateTo

Mar 7 '07 #2

c9stealth

That didn't get the results I wanted... thanks though..

There are other factors to consider:
__1 Suppose either txtDateFrom or txtDateTo or both are Null (missing value(s))?
__2 Suppose non-Date values are entered into this/these Fields?
__3 <= and >= imply inclusion, so the SQL could return a value within the Range when it shouldn't.
__4 Shouldn't the SQL be?

Expand|Select|Wrap|Line Numbers

'Dates falling outside the Window

[StartDate] < Form_frmReports!txtDateFrom AND [EndDate] > Form_frmReports!txtDateTo

Mar 7 '07 #3

Similar topics

303

BIG successes of Lisp (was ...)

by: mike420 | last post by:

In the context of LATEX, some Pythonista asked what the big successes of Lisp were. I think there were at least three *big* successes. a. orbitz.com web site uses Lisp for algorithms, etc. b....

Python

Show Subwindow

by: Venkat | last post by:

Hi All, I have got two windows namely parent and a child . My parent window has got a link, on clicking which opens a child window(i am using window.open function). I do the following set...

Javascript

Opera 7.23 doesn't show me inner tables

by: Mariusz Jedrzejewski | last post by:

Hi, I'll be very grateful if somebody can explain me why my Opera 7.23 (runing under linux) doesn't show me inner tables. Using below code I can see only "inner table 1". There is no problem with...

HTML / CSS

ToolTip.Show(..), where?

by: Lucian Wischik | last post by:

I'm using ToolTip.Show(x,y,..) to show my balloon-style tooltip at a specified coordinate. Most of the time it works fine and the "tip" of the balloon points exactly to my specified (x,y)...

C# / C Sharp

Why people use this style of javascript declaration?

by: howachen | last post by:

e.g. <script type="text/javascript" src="js/common.js"></script> but not <script type="text/javascript" src="js/common.js" /> for any reason?

Javascript

Show ToolTip on every Control continuously

by: Pieter | last post by:

Hi, Using VB.NET 2.0, Windows Forms. I want the ToolTip to be shown on every TextBox, ComboBox and DataGridView continuously, and show the contence of these controls. Is there a way to add the...

.NET Framework

about Show Method in Control Class under System.Windows.Forms (C#)

by: =?Utf-8?B?QWxiZXJ0IEZ1?= | last post by:

Hi, my function: myAdjustForm.Show(); I am using the Show method to show the pop-up window to the users in my C# program. I found that I have invoke this function TWICE at the beginning...

C# / C Sharp

Killing people with C - sourcecode???

by: Lucas J. Riesau | last post by:

I'm a serial killer and unlike other killers I don't kill people with guns, knives or chainsaws. I kill people with software. By reading the sourcecode of one of my programs, the victim's brain...

C / C++

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware