A little SQL code

[leslied]

This SQL code is currently performing what it was set out to do:

SELECT [account] & " " & [project] & " " & [sof] & " " & [sector] & " " & [lastcode] AS udak_field, dbo_DCA_ldr_acct_bal_ext.ministry, qry_ministry.ministry_desc AS min_desc, dbo_DCA_ldr_acct_bal_ext.program, qry_program.prog_desc, dbo_DCA_ldr_acct_bal_ext.subprog, qry_subprog.subprog_desc AS sub_desc, dbo_DCA_ldr_acct_bal_ext.account, dbo_DCA_ldr_acct_bal_ext.project, dbo_DCA_ldr_acct_bal_ext.sof, dbo_DCA_ldr_acct_bal_ext.sector, dbo_DCA_ldr_acct_bal_ext.lastcode, dbo_DCA_ldr_acct_bal_ext.acct_descp_1, dbo_DCA_ldr_acct_bal_ext.acct_descp_2, dbo_DCA_ldr_acct_bal_ext.auth, dbo_DCA_ldr_acct_bal_ext.estm, dbo_DCA_ldr_acct_bal_ext.prevbal, dbo_DCA_ldr_acct_bal_ext.total, dbo_DCA_ldr_acct_bal_ext.per_amt, IIf([estm]=0 And [auth]=0 And [per_amt]=0,0,1) AS Expr1, dbo_DCA_ldr_acct_bal_ext.soc, dbo_DCA_ldr_acct_bal_ext.soc_chr, qry_soc.soc_desc, [auth]-[total] AS bal, qry_period.END AS prd_end_date
FROM ((((dbo_DCA_ldr_acct_bal_ext LEFT JOIN qry_ministry ON dbo_DCA_ldr_acct_bal_ext.ministry = qry_ministry.ministry_id) LEFT JOIN qry_program ON dbo_DCA_ldr_acct_bal_ext.program = qry_program.program) LEFT JOIN qry_subprog ON dbo_DCA_ldr_acct_bal_ext.subprog = qry_subprog.subprog) LEFT JOIN qry_period ON dbo_DCA_ldr_acct_bal_ext.period = qry_period.pd_nbr) LEFT JOIN qry_soc ON dbo_DCA_ldr_acct_bal_ext.soc = qry_soc.soc;

However, there are certain exclusions I would like it to have; eg. I want it to exclude these accounts: 99999, REV, EXP How can I do this and where in this SQL code can I include it? I would apreciate some help guys... thanks

 

[dhookom]

Add it to the end of your SQL
qry_soc.soc
WHERE Account Not IN ("99999", "REV", "EXP"


Duane
MS Access MVP