Query By Date Range

[RoadKill]

Okay, so I am having issues querying (sp?) by date range in my Results page.

This is how the SQL looks on the Access database: HAVING (inputdate) Between
[Enter Start Date] And [Enter End Date].

I then run the wizard and ensure it adds a search form which doesn't work.

So I then copy this SQL and paste it into the Custom Query option of the
Wizard which tells me it is illegal.

There has to be a way to do this, but how is the problem.

Any help would be appreciated.

Thanks

 

[Kathleen Anderson]

The code in the Database Results Wizard or the Database Interface Wizard
that is generated by FrontPage, does not support querying a date/time data
type in an Access database.

See
FP2002: Error Querying Date/Time Fields in Access Databases
http://support.microsoft.com/default.aspx?scid=kb;en-us;284843


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[RoadKill]

Just an FYI, I found a way to do it that seems to work pretty well. Rather
than the query database side, I used the Wizard. Under Criteria, I set up a
Parameter by setting the Field as Greater than the Value of [StartDate]. I
then did Less than for date with Value as [EndDate] and then made sure to add
the Search Form fields when closing the Wizard.

The code in the Database Results Wizard or the Database Interface Wizard
that is generated by FrontPage, does not support querying a date/time data
type in an Access database.

See
FP2002: Error Querying Date/Time Fields in Access Databases
http://support.microsoft.com/default.aspx?scid=kb;en-us;284843


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

Okay, so I am having issues querying (sp?) by date range in my Results
page.

This is how the SQL looks on the Access database: HAVING (inputdate)
Between
[Enter Start Date] And [Enter End Date].

I then run the wizard and ensure it adds a search form which doesn't work.

So I then copy this SQL and paste it into the Custom Query option of the
Wizard which tells me it is illegal.

There has to be a way to do this, but how is the problem.

Any help would be appreciated.

Thanks