Creating a Query for Records Between Two Dates in MS Access 'ms access query between two dates'

In this article, we will cover the steps to create an SQL (Structured Query Language) statement that retrieves records from a table based on specific date ranges using Microsoft Access. We assume you have already created a table named 'myTable' with columns for startTime and finishTime.

### Step 1: Open the Database

Open your MS Access database where you want to create this query.

### Step 2: Create New Query

Click 'Queries' in the Navigation Pane, then click on 'New Object', choose 'Query Design'.

### Step 3: Choose Table Name

In the 'Select' field at top of new query window double-click your table name (e.g., myTable).

### Step 4: Add Date Columns to Query

Drag and drop both startTime and finishTime columns from the 'myTable' table into the 'Criteria' section below them. The syntax should now look something like this:

```sql

SELECT

'yourTableName'.startTime,

'yourtableName'.finishTime

FROM

myTable AS 'yourtableName'

WHERE

('yourtableName'.'startTime' >= #12/31/13#) AND ('yourtableName'.'endTime' <= #01-01-14 23:59:59.999999)

```

### Step 5: Run the Query

Click 'Run' button at top of query window to see results.

By following these steps, you can easily create a MS Access query that retrieves records between two specific date ranges based on your needs.

Ms access query between two dates