Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Jhust1

  1. Jhust1

    SQL Multiselect Query and Unexpected Results

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

    SQL Multiselect Query and Unexpected Results

    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...
  3. Jhust1

    SQL Multiselect Query and Unexpected Results

    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...
  4. Jhust1

    SQL Multiselect Query and Unexpected Results

    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]...
  5. Jhust1

    SQL Multiselect Query and Unexpected Results

    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...
See more

Part and Inventory Search

Back
Top