I am working on a DB and I am stumped as to how can I generate a report that will showcase just the information on the entry form as a report. I tried creating a 'preview report' button but it just displays ALL information that was entered into the DB.
This database is supposed to keep track of insurance carrier's monthly statements. A user would enter the premiums and commission amounts. The subform on the Statement Entry screen is tied to the carrier, so it will show the total amount (premium,commission,cancel commission,cancel premium) of the carrier's figures that have been previously entered. Now if the user hits the 'preview report button' it will show all entries, regardless of the carriers. I tried creating a search screen but it did not work at all.
I would greatly appreciate it if somebody knowledgeable in Access could assist me or go over the DB and spot where my error is. it is not totally complete but this is just a bump in the road.
You can access the DB i am referring to at:
http://fastbreaknyunltd.com/CashRecieptsAnalysis.zip
Thanks a lot