Date help in Access 2003 query - Microsoft Access / VBA

I am running a query in Access 2003 to pull training courses with a start date that falls within a specified date span such 2/1/07 to 2/28/07. I was using this code - (( I.STARTDATE) Between #2/1/2007# And #2/28/2007#) - but found this excluded courses beginning on the first and last date of my date range. I changed the code to this - (( I.STARTDATE) Between #1/31/2007# And #3/1/2007#) and retreived my missing records, but found I was pulling in courses for 1/31/07 (not sure why?). So I tried to add additional criteria such as this - AND (( I.STARTDATE) > #1/31/2007#) AND (( I.STARTDATE) < #3/1/2007#), but I am still getting incorrect data. Can someone help me with the correct code to pull records within a specified date span such as 2/1/07 through 2/28/07. I am sure this is simple, but I am new and self taught, so I need assistance. Thank you.

Mar 28 '07 #1

Subscribe Post Reply

1522

heckstein

I am running a query in Access 2003 to pull training courses with a start date that falls within a specified date span such 2/1/07 to 2/28/07. I was using this code - (( I.STARTDATE) Between #2/1/2007# And #2/28/2007#) - but found this excluded courses beginning on the first and last date of my date range. I changed the code to this - (( I.STARTDATE) Between #1/31/2007# And #3/1/2007#) and retreived my missing records, but found I was pulling in courses for 1/31/07 (not sure why?). So I tried to add additional criteria such as this - AND (( I.STARTDATE) > #1/31/2007#) AND (( I.STARTDATE) < #3/1/2007#), but I am still getting incorrect data. Can someone help me with the correct code to pull records within a specified date span such as 2/1/07 through 2/28/07. I am sure this is simple, but I am new and self taught, so I need assistance. Thank you.

As soon as I posted this I realized / figured out that I could >= and <=, so I now seem to have it working.

Mar 28 '07 #2

Similar topics

SQL-Query Access by Date

by: Cady Steldyn | last post by:

Microsoft SQL Server

Date Functions in Access 2000

by: Craig Bates | last post by:

Hi Guys I have recently been learning SQL from a book whose examples used the Oracle engine. I have now made an Access database containing information for English Football fixtures. I am using...

Microsoft Access / VBA

ORDER DATABASE FIELDS by DATE VALUES for EACH RECORD

by: Joe User | last post by:

Hi all....I have a feeling this is going to be one of those twisted query questions, but here it goes anyways.... I want to generate a report that shows the chronology of events (represented by...

Microsoft Access / VBA

Can max be used on a date field?

by: Bayla Frankl | last post by:

Hi all, I am a little stumped. I have a query I am trying to run to retrieve the last Progress Note record from the database for the current patient so that the therapists can see the last note...

Microsoft Access / VBA

Finding records by date range?

by: Gary | last post by:

Sorry to waste everyone's time with a query which is so simple, but as a new user of Access I have created a client database and one of the fields is "next contact due" as the name implies, this is...

Microsoft Access / VBA

Counting Records by Date where there are several groups of dates

by: BlackFireNova | last post by:

I have an Access 2003 mdb which contains software records. I need to sort on a particular type of software, and then identify and count how many copies there are per each group of that type...

Microsoft Access / VBA

highest and lowest date

by: nick_faye | last post by:

hi guys, im still a newbie in ms-access and i would like to ask how can i get the highest and the lowest date in ms-access report? for example, i have these entries: 10/1/2003 10/5/2003...

Microsoft Access / VBA

Date in Query

by: Kenneth | last post by:

I have a Query that consist of a lot of different sales data, and one of the colums are different date. The date goes from 1jan2003 til 31jan2003. in this Query I only want the salesdata for...

Microsoft Access / VBA

Date Selected query parameter

by: ED | last post by:

I currently have an ODBC query that hits an Oracle database. I want to bring back records for a given month based on a job completion date in the Oracle database. I would like to have the user...

Microsoft Access / VBA

date criteria in VB Express query

by: Daniel | last post by:

In Microsoft Access I can write a query that includes the criteria: Between Date()-7 And Date() to retrieve the records from a table that fall within the last week. I'm trying to write a...

Visual Basic .NET

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

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

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