Complicated Report Filtering
I have a report that needs to be run that is fairly complex (at least I think it is). I have a table with a list of batches of products we make with the date and the average tax of the batch. The first report was easy, it needed to take the average tax of the batches in the last 6 months, I already have that one done. The next one will need to return the last record of a batch only if it has not been made in the last 6 months (it has the last 6 month average stored in it) and show me what the average number was. I was wondering if anyone had any good ideas on how to accomplish this? Thanks!