Getting report from current data on form

[tblues87]

Hi
I didn't know how to title this thread but the problem is next.
I need a report that will be used as bill.
First I made a form that is based on query that gives me information about person that pays. On the same form I made a sub-form for paying details like: paying date and amount of paying.

Now because paying can be on credit, as it usually is, when person pays his first credit I need a report to print all the information from main form and only the current date and amount of paying.

Thanks

 

[Trevor G]

what I suggest is make a query that uses the tables and set criteria to use the relevant field for your date which is equal to date()

Date() means todays date