'Select records where more than one field has data in the same record - a customer can order one or more books
Example of the Database Fields fields on table I'm trying running a SQL query from an Excel spread sheet that is used for printing packing slips and labels.
The query runs on a table where each row has a unique customer. Each row also has multiple columns with a date if a book was ordered by a customer. I need to pull only the rows where a customer has ordered more than one book regardless of the date ordered.
If a row only has one book column with a order date I want to skip that row. If a row has more then one book column with an order date I want to pull that row to my spread sheet.
Solution 1:[1]
What is the formatting of your table? Is this one line per order, one line per customer? Showing us a sample of data in the table, and the data you'd like to get would go a long way here.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Brandon_R |