1. Home
  2. Point-Of-Sale Software
  3. customer address report

customer address report

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

Reply to
DCR
Loading thread data ...

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:

Reply to
Daniel

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.