ACCESS doesn't like the brackets

[Guest]

[Posting on behalf of the customer as shes not able to access this site.]

What's wrong with my statement?
ACCESS doesn't like the brackets - even when I remove the brackets before
and after the "!" ? Please help..

=[Forms]![IssuesSearch]![OpenedDate1] And [OpenedDate]<[Forms]![IssuesSearch]![OpenedDate2]+1

Tammy Jones
UPS Supply Chain Solutions

 

[Guest]

It is not a matter of you brackets. You are creating a wrong formula like
this --

= 2/1/2006 And 3/4/2006 < 4/5/2006 +1

= 2/1/2006 And 3/4/2006

It can not be greater than a date and equal to another at the same time.

3/4/2006 < 4/5/2006 +1
You can not have criteria like this.

=[Forms]![IssuesSearch]![OpenedDate1] And [OpenedDate]<[Forms]![IssuesSearch]![OpenedDate2]+1

Tammy Jones
UPS Supply Chain Solutions

 

[Guest]

[Posting on behalf of the customer as shes not able to access this site.]

I'm creating a form where a user can search for opened items between two
dates, two date fields. And in the Parameters portion of the query I've got:

Forms!IssuesSearch!OpenedDate1 DATETIME
Forms!IssuesSearch!OpenedDate2 DATETIME

And I was told by one of your experts to type the following in the criteria
of the query:

=[Forms]![IssuesSearch]![OpenedDate1] And [OpenedDate]<[Forms]![IssuesSearch]![OpenedDate2]+1

Tammy Jones
UPS Supply Chain Solutions

 

[Guest]

I do not profess to be an expert, just a self-taught amature. The plus one
on the end is because many use Now() to fill in dates but it also contains
the time. If you just use the date as criteria it is as of midnight (no time
component) and will not pull records entered with time after midnight.

You can just use this as the criteria --
Between [Forms]![IssuesSearch]![OpenedDate1] And
[Forms]![IssuesSearch]![OpenedDate2]+1

If you still have problems then post your query SQL by opening in design
view, click on menu VIEW - SQL View. Hightlight, copy, and paste in a post
for someone to take a look at it.

[Posting on behalf of the customer as shes not able to access this site.]

I'm creating a form where a user can search for opened items between two
dates, two date fields. And in the Parameters portion of the query I've got:

Forms!IssuesSearch!OpenedDate1 DATETIME
Forms!IssuesSearch!OpenedDate2 DATETIME

And I was told by one of your experts to type the following in the criteria
of the query:

=[Forms]![IssuesSearch]![OpenedDate1] And [OpenedDate]<[Forms]![IssuesSearch]![OpenedDate2]+1

Tammy Jones
UPS Supply Chain Solutions