Search results

  1. A

    "Data type mismatch in criteria expression" after changing criteria

    I have a query that pulls out student assessment data. It was looking at 2014/15 data but now it's come time to move on to 2015/16 data. I have two lines (by lines, I mean lines in design view, not lines of SQL code) of criteria on my query, each of which filter by academic year. After updating...
  2. A

    IIf in query criterion

    Hello, I'm trying to use IIf in a query criterion, but not having any luck. I have a field called 'ayr_code' which has values in the format: 2015/6 2014/5 2013/4 2012/3 2011/2 2010/1 2009/0 2008/9 I want to return all records where in this field: if the current month is November or...
Top Bottom