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
customer address report
Sep 29, 2008
1 Replies
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:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required