I am trying to create a report based on some date fields in our database. We have "Fixed", "Verified", "Delivered", and "Closed" (all date fields). Selection for the report needs to be based on if ANY of those fields have a date in them (but at least one must be filled in). I would then really like to have a report that groups items into a Fixed, Verified, Delivered, and Closed category. The fixed report section will have entries that only have a Fixed date in them. The Verified section will have the verified date filled in, may or may not have the fixed date filled in, and will not have the delivered or closed dates. The Delivered section will have the delivered date filled in, but may or may not have the preceding dates, and won't have the closed date. Etc.
Am I dreaming? Can this be done? Is there some way to run a pre-query that assigns a temporary table value based on which dates are filled in and then generate the report with that?
Thanks!
Am I dreaming? Can this be done? Is there some way to run a pre-query that assigns a temporary table value based on which dates are filled in and then generate the report with that?
Thanks!