Reporting from SQL

[fcl22]

Sql has the data, I have a view that tells me what each customer bought. I would like to print out a report (ms Access project) that shows just what the person purchased and not the 0 values. Not sure how to get my arms around it.

thank you

fred

 

[tlbroadbent]

Can you modify the View? If yes, add Where Amout <> 0 or similar criterion to the view. Alternatively, you can filter the report.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm