Entering current date in input box

[Guest]

Hello,

I have an input boxes that come up as a result the synatx 'Between [Enter
Start Date] And [Enter End Date]' against criteria under the field 'Date' in
one of my queries. It is working fine, but I want to avoid the monotony of
having to enter both the start and end date if they both happen to be the
current date. I was just wondering if it would be possible for the current
date to the automatically inputted for both entry requirements by a double
click of the mouse in the input boxes.

Thanks for your expected usual support.

Alylia

 

[John Spencer]

No double click, but you just hit return instead of entering anything in the
parameter request.

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Date)

And if you just wanted to enter the start date and have the end date
default to the entered start date

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Nz([Enter
Start Date],Date))

 

[Guest]

Thank you for your prompt response.

I tried the syntax "Between Nz([Enter Start Date],Date) And Nz([Enter End
Date],Date)" and it has not worked. It give me the error msg "this expression
is type incorrectly or is too complex to be evaluated". I also noticed that
the syntax changes to Between Nz([Enter Start Date],"Date") And Nz([Enter End
Date],"Date") when I run the query.

Thanks for your continued support.

No double click, but you just hit return instead of entering anything in the
parameter request.

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Date)

And if you just wanted to enter the start date and have the end date
default to the entered start date

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Nz([Enter
Start Date],Date))

Hello,

I have an input boxes that come up as a result the synatx 'Between [Enter
Start Date] And [Enter End Date]' against criteria under the field 'Date'
in
one of my queries. It is working fine, but I want to avoid the monotony of
having to enter both the start and end date if they both happen to be the
current date. I was just wondering if it would be possible for the current
date to the automatically inputted for both entry requirements by a double
click of the mouse in the input boxes.

Thanks for your expected usual support.

Alylia

 

[John Spencer]

My error. I should have used Date() instead of Date. I forgot the Parens
to make the database recognize that I was using the Date function

Between Nz([Enter Start Date],Date()) And Nz([Enter End Date],Date())

Thank you for your prompt response.

I tried the syntax "Between Nz([Enter Start Date],Date) And Nz([Enter End
Date],Date)" and it has not worked. It give me the error msg "this
expression
is type incorrectly or is too complex to be evaluated". I also noticed
that
the syntax changes to Between Nz([Enter Start Date],"Date") And Nz([Enter
End
Date],"Date") when I run the query.

Thanks for your continued support.

No double click, but you just hit return instead of entering anything in
the
parameter request.

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Date)

And if you just wanted to enter the start date and have the end date
default to the entered start date

Between Nz([Enter Start Date],Date) And Nz([Enter End Date],Nz([Enter
Start Date],Date))

Hello,

I have an input boxes that come up as a result the synatx 'Between
[Enter
Start Date] And [Enter End Date]' against criteria under the field
'Date'
in
one of my queries. It is working fine, but I want to avoid the monotony
of
having to enter both the start and end date if they both happen to be
the
current date. I was just wondering if it would be possible for the
current
date to the automatically inputted for both entry requirements by a
double
click of the mouse in the input boxes.

Thanks for your expected usual support.

Alylia