Forum Discussion
IIf Function Access Query
New Query, Comparing 2 tables. Table 1 System Accounts Joined by: Company Name (Short Text) Table 2 Database Accounts Joined by: Company Name (Short Text) I would like to make sure the Acco...
XPS35 SELECT [SSRS- AX Accounts].Site, [Master List].Site, [Master List].[Upload to AX], [Master List].[Account Number], [SSRS- AX Accounts].[Cust #], [SSRS- AX Accounts].[Address type],
IIf([Master List]![Account Number]=[SSRS- AX Accounts]![Account # ],"Good","Bad") AS Expr1
FROM [SSRS- AX Accounts] INNER JOIN [Master List] ON [SSRS- AX Accounts].Name = [Master List].[Upload to AX]
WHERE ((([SSRS- AX Accounts].Site)="3001") AND (([Master List].Site)="3001") AND (([SSRS- AX Accounts].[Address type]) Like "*delivery*"));The Fields in my previous post do not reflect this SQL. Please let me know if I need to update those for less confusion.
