Em Andamento

SQl Statement to show invoices with small gains

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.

## Deliverables

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.

## Platform

Windows 2000

Habilidades: Engenharia, Microsoft, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Visual Basic, Área de trabalho do Windows

Ver mais: return invoice sample, make money job, make dollars, html command, sql server job, sql less, job invoices, webbrowser, sql server reporting, sql database report, report sql, job interior, database html sql, vehicle database project access, invoices sql server, sql database relationship, customer invoice report, access webbrowser, web reporting sql database, php sql 2000, sql mdb, code export report php, sql report access, invoices html, small parts

Acerca do Empregador:
( 781 comentários ) Sydney, Australia

ID do Projeto: #2996020

Premiar a:

agiletechvw

See private message.

$17 USD em 2 dias
(36 Avaliações)
6.5