September 5, 200520 yr I hope this is the right place to ask this. My customer wants me to make several reports. The first one is all information in the database. The next two is what I have problems with. I have to print all records that show an item that has not sold. The field I would have to work off of is Date Sold, if there is nothing in this field than I need that record printed. So the report would have Manuf,Remarks,Model,Cal,Received Date,cost of item. How would I go about doing this. The other issue is: I need a report that would find the tax amount after a certain date. So for example: I need to know all the tax money I brought in after September 10th, or from Sept 10th to Sept 20th. How would I do that. It would work off of the field "Tax Amount" I know this is long. I am new at doing reports. Thank you.
September 7, 200520 yr Find all records with something in Date Sold, I usually enter >1/1/1900 assuming you do not have tax payments prior to 1/1/1900, then print. Second question depends upon how you have the tax data entered. If you create a new record for each tax deposit, simply find for the dates in the ranges you require, 9/10/05...9/20/05. Check out the manual for finds, it will give you much more information!
Create an account or sign in to comment