P
pepenacho
Hello,
does anyone know whther or not some variation of this statement is possible
Here is the example, I have a table with one field. the field contains
unique numbers as data. I want to write a query that spits out back the
contents of the table and an additional field that is created in the macro.
That field should be a bunch of IF statements, which in the end will assign a
unique label to each number.
In query, can use a bunch off IFFs somehow to get that result?
Field2: IIf([Table1].[Field1]="1","AA") Or IIf([Table1].[Field1]="2","BA")
I guess it's an attempt to write an if then statement without running it
through code.
Thanks,
pepenacho
does anyone know whther or not some variation of this statement is possible
Here is the example, I have a table with one field. the field contains
unique numbers as data. I want to write a query that spits out back the
contents of the table and an additional field that is created in the macro.
That field should be a bunch of IF statements, which in the end will assign a
unique label to each number.
In query, can use a bunch off IFFs somehow to get that result?
Field2: IIf([Table1].[Field1]="1","AA") Or IIf([Table1].[Field1]="2","BA")
I guess it's an attempt to write an if then statement without running it
through code.
Thanks,
pepenacho