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!
Can't really offer any help without first knowing what you have in terms of tables and relationships for managing this data on your batches. I suggest using Post a New Answer to provide a more detailed description of how your system manages this information and what tables/relationships are used to do so.