Getting Rid Of Enter Parameter Value (1 Viewer)

huss1

New member
Local time
Today, 06:23
Joined
May 31, 2012
Messages
1
Hi I am an amateur Access user and have a query where i keep getting the enter parameter value appearing on 3 separate occassions. The query works fine by clicking ok 3 times but i would prefer it not to appear.

The SQL is as below:

SELECT [Analysis & Cost Centre Data].[Cand ID], [Analysis & Cost Centre Data].[Engt ID], [Analysis & Cost Centre Data]!Forename & " " & [Analysis & Cost Centre Data]!Surname AS [FL Name], [Analysis & Cost Centre Data].Status, [AS400 AC Table].COFA, [Analysis & Cost Centre Data].[Req Class Name], [Analysis & Cost Centre Data].Directorate, [Analysis & Cost Centre Data].Category, [Analysis & Cost Centre Data].[Vendor Type], [Analysis & Cost Centre Data].[Analysis Code], [AS400 AC Table].[AS400 AC], IIf([Analysis & Cost Centre Data]![Analysis Code]=[AS400 AC Table]![AS400 AC],"AC Match","AC No Match") AS [AC Match], [Analysis & Cost Centre Data].[Bill Type], IIf([AS400 AC Table]![AS400 AC] In ("CBMAD","CBMAE","CBMAZ"),"ADM WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMA3","CBMA4","CBMA6"),"BA WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMAF","CBMAG","CBMA1"),"EAD WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMA7","CBMA8","CBMA9"),"PM WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMT","CBMU","CBMV"),"PMO WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMAH","CBMAJ","CBMA2"),"ITSD WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMX","CBMY","CBM1","CBMW"),"Main GIT Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMAA4","CBMAA5","CBMAA6","CBMAA7"),"Non GIT Bill","Non GIT Bill")))))))) AS [AS400 Bill Type], IIf([Analysis & Cost Centre Data]![Bill Type]=[AS400 Bill Type],"Bill Type Match","Bill Type No Match") AS [Bill Type Match], IIf([Bill Type Match]="Bill Type No Match" And [AC Match]="AC No Match","Priority 1",IIf([Bill Type Match]="Bill Type Match" And [AC Match]="AC No Match","Priority 2",IIf([Bill Type Match]="Bill Type Match" And [AC Match]="AC Match","Priority 3",""))) AS Priority
FROM [Analysis & Cost Centre Data] INNER JOIN [AS400 AC Table] ON [Analysis & Cost Centre Data].Cofa = [AS400 AC Table].COFA
GROUP BY [Analysis & Cost Centre Data].[Cand ID], [Analysis & Cost Centre Data].[Engt ID], [Analysis & Cost Centre Data]!Forename & " " & [Analysis & Cost Centre Data]!Surname, [Analysis & Cost Centre Data].Status, [AS400 AC Table].COFA, [Analysis & Cost Centre Data].[Req Class Name], [Analysis & Cost Centre Data].Directorate, [Analysis & Cost Centre Data].Category, [Analysis & Cost Centre Data].[Vendor Type], [Analysis & Cost Centre Data].[Analysis Code], [AS400 AC Table].[AS400 AC], IIf([Analysis & Cost Centre Data]![Analysis Code]=[AS400 AC Table]![AS400 AC],"AC Match","AC No Match"), [Analysis & Cost Centre Data].[Bill Type], IIf([AS400 AC Table]![AS400 AC] In ("CBMAD","CBMAE","CBMAZ"),"ADM WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMA3","CBMA4","CBMA6"),"BA WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMAF","CBMAG","CBMA1"),"EAD WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMA7","CBMA8","CBMA9"),"PM WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMT","CBMU","CBMV"),"PMO WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMAH","CBMAJ","CBMA2"),"ITSD WO Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMX","CBMY","CBM1","CBMW"),"Main GIT Bill",IIf([AS400 AC Table]![AS400 AC] In ("CBMAA4","CBMAA5","CBMAA6","CBMAA7"),"Non GIT Bill","Non GIT Bill")))))))), IIf([Analysis & Cost Centre Data]![Bill Type]=[AS400 Bill Type],"Bill Type Match","Bill Type No Match"), IIf([Bill Type Match]="Bill Type No Match" And [AC Match]="AC No Match","Priority 1",IIf([Bill Type Match]="Bill Type Match" And [AC Match]="AC No Match","Priority 2",IIf([Bill Type Match]="Bill Type Match" And [AC Match]="AC Match","Priority 3","")));

Any help would be appreciated.

Thanks

Huss1
 

KenHigg

Registered User
Local time
Today, 09:23
Joined
Jun 9, 2004
Messages
13,327
If you want to pretty up this sql by re-formatting it in code tags someone may be willing to take a stab at it :)
 

Users who are viewing this thread

Top Bottom