Search results for query: *

The problem was/ is not the [] - thanks anyway. I figured it out on my own.

The change was made as you suggested - but the report is still not retrieved. The Debug.Print now displays: *------------------------------------------------------* [Arrival_State] IN (1) AND DateValue[Arrival_Date] >=#2/01/2004# AND DateValue[Arrival_Date]<=#2/4/2004...

Thanks for your quick reply, I had previously unsuccessfully used ([Arrival_Date]) without the cDate - as this is a Date/Time Field and does not need to be converted ----- but I was following some advice to use cDate because I was told: &quot;On dates, even if you don't enter time, Access will...

Hello, the Hidden_Box is located on my Search Form to store the values of the List Box (List_States) and I use the AfterUpdate code below. The Debug.Print will display for example the code *--------------------------------------------------* | [Arrival_State] IN (1) AND cDate[Arrival_Date]...

Greetings, I am working on my second Database and need help with this query. The query is attached to a Filter Form with a Hidden_Box, which allows the user to select a single or multiple states from a List Box, then choose a beginning and ending date range from a popup calendar. The filter...