I played around with this and came up with an answer. Here is the code I wrote: Intake1:iif([field1]="a" and [field2]="x" or[field1]="a" and ([field2]& [field3])="xx",1,0) Intake2:iif([field1]="a" and ([field2]&[field3)]="x",1,0) The result works. --- In AccessDevelopers@yahoogroups.com, "chrisman052003" <[EMAIL PROTECTED]> wrote: > > I am trying to run a query with a specific criteria using iif. > In column A I have Intake1:iif([field1]="a" and [field2]="x" or > [field1]="a" and [field2]="x" and [field3]="x",1,0) > In column B I have Intake2:iif([field1]="a" and [field3]="x",1,0) > The trouble I am having is if a record has an A in field1, and an X in > field2 and an X in field3, Intake1 counts 1 and Intake2 counts 1. > I expected only to see a 1 in Intake1 and a 0 in Intake2. > Any help would be appreciated. >
------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
