Recent content by Xevon

  1. X

    Preventing #Error with CDate in queries

    It was just me, not paying attention to details. Here's what I intended: SELECT dbo_Stock.stk_item_no, dbo_SalesItems.s_descript, dbo_Stock.stk_inv_qttytd, dbo_Stock.stk_row, dbo_Stock.stk_aisle, dbo_Stock.stk_bin, IIf(IsDate([stk_bin]),CDate([stk_bin]),"") AS bin FROM dbo_SalesItems INNER JOIN...
  2. X

    Preventing #Error with CDate in queries

    Very intersting: If I change the IIf then I get correct results but when I use it in a WHERE clause, it returns no rows (okay three): SELECT dbo_Stock.stk_item_no, dbo_SalesItems.s_descript, dbo_Stock.stk_inv_qttytd, dbo_Stock.stk_row, dbo_Stock.stk_aisle, dbo_Stock.stk_bin...
  3. X

    Preventing #Error with CDate in queries

    The field is text, IsDate returns negative for all, thanks though!
  4. X

    Preventing #Error with CDate in queries

    I'm working on a query in the Access 2019 query editor that pulls from a table with a text field containing both text and dates, none of which are uniform in any way. For instance a date could look like 02-15-22 or 2/15/2022, and various strings that are not dates. Using the CDate or DateValue...
  5. X

    Hello from British Columbia, Canada

    Hi Everyone, I'm new to this forum and reaching out to say Hi as requested. I've been programming in MS Access pretty much since it came out, prior to that I used dBase and such the like. I used BASIC when we had BASCOM to comile the programs into executables, and C later, but branched off into...
Top Bottom