Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to get a report to print only bad debt

Status
Not open for further replies.

shaunmj

Vendor
Joined
Mar 15, 2003
Messages
3
Location
GB
i am writing a report which currently hold 2500 records in a table, i currently have a previous invoice total and a current week invoice total i want to print the report via an event procedure so that if the previous invoice total is greater that 3 times the current invoice total then the report will only print records i have tried this but it doesn't seem to work --- If [Prev Tot] > 0 And [Inv Amnt]* 4 > [Prev Tot] Then print


please help i amd desperate to finish this

thanks in advance
 
i have created a database contating 2 tables, which had 1 field from each table related, i created a report to show some fields from table 1 and some fields from table 2, which worked ok, but i have to clear out the records and import new records weekly, so i have inported this weeks new records but now the reports wont preview any records on blank pages, can anyone please help, it also happens if i create a new report on the same data %-(
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top