If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DatePart in Filter By Form field
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? |
Thread Tools | |
Display Modes | |
|
|