| :: Q re SQL to asp rep wzrd :: (2) | Post a New Message | Post a Reply |
 Q re SQL to asp rep wzrd | Post a Reply |
since: Oct 1, 2003
from: somewhere
SELECT custs.custid, custs.custName
FROM custs LEFT JOIN ords ON custs.custid = ords.CustId GROUP BY
custs.custid, custs.custName, ords.CustId HAVING (((ords.CustId) Is Null Or
(ords.CustId)<>"2"));
if so how?
thank you.
* excuse this post if dup
 Re: Q re SQL to asp rep wzrd | Post a Reply |
from: Washington, DC
2. Select the custid and custName fields from the Custs table.
Also enter the relatioship in the relationship text box
custs.custid = ords.CustId 3. Navigate to the section Add filters to your report. (Click Next twice)
4. Select Ords.CustID (field) and IS NULL (filter) and Click Add Filter
5. Select the option OR where it says Connect filters using
4. Select Ords.CustID (field) and is not equal to (filter), enter 2 (Value) and Click Add Filter
5. Click Next. Select Summary Report
6. Click Next. Select Add record count
7. Click Finish
SELECT custs.custid, custs.custName
FROM custs LEFT JOIN ords ON custs.custid = ords.CustId GROUP BY
custs.custid, custs.custName, ords.CustId HAVING (((ords.CustId) Is Null Or
(ords.CustId)<>"2"));
-------------------------
Ghost