Can I enter two parameters in a querie (1 Viewer)

M

MadeCurler

enthusiastic pensioner

Local time

Today, 10:39

Joined

Dec 6, 2007

Messages

49

• Oct 19, 2012

• #1

I want to extract data from a querie based on two dates supplied (as parameters) by the user. How do I do that?

 

A

AccessMSSQL

Seasoned Programmer-ette

Local time

Today, 02:39

Joined

May 3, 2012

Messages

636

• Oct 19, 2012

• #2

In the criteria row of your query grid type this under the date column you wish to query:

Between [enter start date] and [enter end date]

 

M

MadeCurler

enthusiastic pensioner

Local time

Today, 10:39

Joined

Dec 6, 2007

Messages

49

• Oct 19, 2012

• #3

Figured it out myself...

Between [Please enter the start date] And [Please enter the finish date]