Basically I have two separate payments that are stored in the same table, and I need to generate a report showing all payments made in a certain time frame. The two payments do not always fall into the same time frame, so I need the report to only show the payment if it occurred in the specified time frame. I would like the field to be left blank in the report if the payment has not been made or was made outside of the specified time frame.
My fieldss are basically: Name, 1stPaymentDate, 1stPaymentAmount, 2ndPaymentDate, 2ndPaymentAmount
I need the report to show all the fields, but leave the dates and payments blank if they fall outside the time frame. What approach should I take?