DatePart in Filter By Form field

D

Danny

Howdy.

I've got a form based on a query, with a column in that query using the
DatePart function. Here's that field definition:

WeekDay: DatePart("w",[tourdate])

In the query, the values are correctly returned (1-7).

In the form, those values display correctly.

When I apply "Filter By Form", the pulldown for this field doesn't show
items 1-7, but shows a list of actual dates - 3/24/2010, for instance.

What's going on?
 

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

Similar Threads

Filter by form search field showing non-distinct values in pull do 1
Filter-by-form and Linked Tables 0
Filter by form with linked tables 0
DatePart in default value 3
Filter by Form not working 0
Can I save a sql statement generated by a search form? 1
Format DatePart 4
filtering a form based on a filter on an open form 2

Top