Query By Date Range

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
 
K

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
 
R

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top