Data range for Web Forms

[need_help12]

Good afternoon.

I have a form I'm converting to a web form which allows end users to search for expiring contracts by entering a date range. In my client db, this was done by putting the following criteria in the StartDate section of the query: "<[Forms]![Navigation_Admin]![Navigation_Subform].[Form]![EndDate]", and this criteria in the EndDate section of the query: "Between [Forms]![Navigation_Admin]![NavigationSubform].[Form]![StartDate] And [Forms]![Navigation_Admin]![NavigationSubform].[Form]![EndDate]"

Upon entering this criteria into my web query for my web form, I was prompted by Access that this is not a valid function for web compatability. What are my options for doing a start date/end date filter for a web form?

[June7]

Which function is not compatible - is it really the BETWEEN AND that is not accepted? Show the complete query sql statement for analysis.

Try:
>=[Forms]![Navigation_Admin]![NavigationSubform].[Form]![StartDate] And <= [Forms]![Navigation_Admin]![NavigationSubform].[Form]![EndDate]"

[need_help12]

Well, that allowed me to run the query no problem, but when I do, it returns all the datasets in my table. I think I'm missing something parameter related, and I simply dont have the web database knowledge.

[June7]

Want to show the complete sql statement for analysis?

[need_help12]

Maybe that's my issue? I'm not using SQL.

[June7]

If you are building queries in Access, then you are using SQL language. Access queries are based on SQL syntax. Open query in SQL View and copy/paste the statement into post.

[need_help12]

I thought there was no SQL View for web databases? Am I mistaken?

[June7]

Ooops, sorry, I have never built web database. Even if there is no SQL View, the sql must be saved somewhere. If hidden sys tables can be viewed in web db, might find the sql in the MySysQueries table.