Home Page link  

customer address report

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
customer address report DCR 09-29-2008
Posted by DCR on September 29, 2008, 6:09 pm
Please log in for more thread options

Does anybody have a report that only shows customer that have all the fields
are filled out such as address, city, state, zip. If the customer fields are
not filled out completely, they don't want the customer showing in the report.
I hope this makes sense.
Thanks
Dave

Posted by Daniel on September 29, 2008, 7:24 pm
Please log in for more thread options

Not a report but you could use this query:

select * from customer
where FirstName <> ''
and LastName <> ''
and Address <> ''
and City <> ''
and State <> ''
and Zip <> ''


DCR wrote:
> Does anybody have a report that only shows customer that have all the fields
> are filled out such as address, city, state, zip. If the customer fields are
> not filled out completely, they don't want the customer showing in the report.
> I hope this makes sense.
> Thanks
> Dave
>

Similar ThreadsPosted
SHOW Customer ADDRESS in Customer FIND WINDOW? May 2, 2006, 3:21 pm
Customer Address May 24, 2006, 4:38 pm
Customer Email Address May 16, 2006, 11:03 am
customer DB email address query November 7, 2006, 6:27 am
email address from customer data base December 21, 2005, 3:50 pm
Update Customer email address using SQL statement - HELP PLEASE!!! December 29, 2005, 9:30 am
Be able to change address and customer account info @ each store May 9, 2006, 9:33 am
Merge duplicate accounts, advanced customer capture, targeted list extraction, address validation February 22, 2008, 10:17 am
Primary Shipping Address vs Address October 19, 2006, 9:59 am
Credit card ADDRESS VERIFICATION! ADDRESS VERIFICATION!!! September 6, 2005, 5:12 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap