By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,223 Members | 1,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,223 IT Pros & Developers. It's quick & easy.

Table query

P: 20
My table query:

SELECT tblCustinfo.ID, tblCustinfo.NAME, tblCustinfo.ADDR, tblCustinfo.tblCustLoc_ID, tblCustLoc.CITY, tblCustLoc.STATE, tblCustLoc.ZIP, tblCustLoc.COUNTY, tblCustinfo.CONTACT, tblCustinfo.PHONE, tblCustinfo.SADR, tblCustinfo.ESTAB, tblCustinfo.CANCEL, tblCustinfo.tblCustAmts_ID, tblCustAmts.SRV_AMT, tblCustAmts.LST_SRV, tblCustAmts.LST_STM, tblCustAmts.PAY_AMT, tblCustAmts.LST_PAY, tblCustAmts.BAL_AMT, tblCustAmts.BLCAT, tblCustinfo.tblMemo_ID, tblMemo.MEM1, tblMemo.MEM2, tblCustinfo.CONTNR, tblCustinfo.CID
FROM ((tblCustinfo LEFT JOIN tblMemo ON tblCustinfo.tblMemo_ID = tblMemo.ID) LEFT JOIN tblCustLoc ON tblCustinfo.tblCustLoc_ID = tblCustLoc.ID) LEFT JOIN tblCustAmts ON tblCustinfo.tblCustAmts_ID = tblCustAmts.ID;

What I would like to do is in tblCustinfo.CANCEL, place a "y" if the customer is canceled but not display any with a "y" in this form. Then using a copy of this query for a form for deleted customers, display only the records with a "y".
How do I set this criteria ?
Jan 24 '08 #1
Share this Question
Share on Google+
1 Reply


P: 20
Never mind - I figured it out, at least a way.

Thanks for the help.
Jan 25 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.