Grouping Specific Data

K

Kevin C

Hi-

I have a query that lists all of a certain type of data
according to a date, "SLA Date". I need a to build a
report that will group records together according to
their SLA Date. I need the first grouping to be Urgent,
and to list all records that have an SLA Data that
equeals today. The next grouping would be records that
have an SLA Date for tomorrow. I need a total of 4
groupings. The other 2 groups would be SLA date of 2
days away, and 3+ days away. Any assistance would be
greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup IF word in string exists within cell, use the word. 0
date calculation in pivot table to show products over agreed date? 0
Monthly job timings analysis - automation options? 2
I have a strange data mismatch error 4
Copy previous record into form field 0
If certain date is past certain date. 3
Automation to calculate the SLA date? 1
How to convert number format to date format? 11

Top