Included is the sample project to show the invoices with gains smaller than specified amounts. In this sample, it should show a list of invoices with gains 5 dollars or less. I already have it so when the command button is clicked, it will export it into html and display it in the webbrowser so I can see the results. What needs to be done is the SQL Statement that will show the gains. Also, it needs to show how many invoices for a customer. Goto <[url removed, login to view]> to download the database because its too big to put here. The relationship is customer.id=[url removed, login to view]
One customer may have more than one invoice. That would be a case where it double shipped. This report should show the list of invoices where I either lost money or did not make enough money. I need an explaination of the changes to the SQL statement so if I wanted to show where I lost money just on shipping, I can modify it for that. If there are bugs in the reporting on the web, don't worry about that. This job is just the SQL statement that will return the necessary records. If there are some invoices with no links to customers, don't worry about that. It should be some type of one to many where one customer may have several invoices. If a customer does not have an invoice, don't show that one either. It also needs to list the number of invoices belonging to the customer where the amount is <>0.
The completed SQL statement to show the report specified. Need the source code only. Need to show the statement as it would show on Access or SQL Server 7.0.