Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    6

    Unanswered: filter query with custom field

    I created a query from a table and added a field that checks another field for a specific character at a specific position. I entered the following expression into the field box in design view:

    ZorA: IIf(Mid$([MoldCode],4,1)="A","Al","Zn")

    This works fine, but my problem is that when I try to filter this column, access does not find any matching criteria and locks up.

    Does anyone know why this won't work?

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    ZorA is a Calculated Field and they sometimes present problems when doing things like sorting, filtering on, etc. Here's a link to Allen Browne's article on the subject, perhaps it'll help:

    Microsoft Access tips: Calculated fields misinterpreted

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •