Query By Date Range

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

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
 
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
 
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.

Kathleen Anderson said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top