Access Report with Day of Week in Column Headings

I have a query that is like the following:

Location      Date Added      Printer      Issue Date-Time      Issue      Resolve Date-Time      Resolution
East                                    
West                                    
North                                    

And I'd like to have it view like this in a report:

Date Added      Monday      Tuesday      Wednesday      Thursday      Friday
East                              
      Printer      Issue Date-Time      Issue      Resolve Date-Time      Resolution
West                              
      Printer      Issue Date-Time      Issue      Resolve Date-Time      Resolution
North                              
      Printer      Issue Date-Time      Issue      Resolve Date-Time      Resolution

Is this possible?
dlmazAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LowfatspreadCommented:
so....?

you need to now specify what those days of the week mean in relation to the rest
of the data....

and what it is that you require help with?
0
dlmazAuthor Commented:
Ok - I've attached a snapshot of the actual data. Hopefully this will assist in clarifying what it is I am trying to accomplish.

The Date Added column was recently added and is a 'date stamp' for the entry of the record. Now it has been requested of me to put this data into a format that will display, grouped by Site Name in the following manner:

(day of the week based on Date Added column)  Monday   Tuesday   Wednesday  Thursday  Friday
Site Name
Printer, IssueDateTime.....
Printer, IssueDateTime....
Site Name
Printer, IssueDateTime....
Printer, IssueDateTime...
Site Name
Printer, IssueDateTime...
Printer, IssueDateTime...

I thought maybe I needed to do a crosstab query but that won't provide the detail for each record. Suggestions?

Thank you.
PDT.jpg
0
hnasrCommented:
This is the data, show the corresponding output.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

hnasrCommented:
Looks like this issue is a candidate for a crosstab query.
0
LowfatspreadCommented:
so you don't want the days of the week listed....

YOU ONLY WANT THE DAYNAME OF THE date of the query displayed....?

Otherwise the structure of the question leads us to believe some sort of Transform/crosstab summation query is required.


try  format(dateadded, "dddd")
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dlmazAuthor Commented:
Thank you for format on the day of the week for the field DateAdded but what I'm not sure how to do is to get the data (the snapshot is the output) to appear in the format noted:
Site Name
Printer, IssueDateTime.....
Printer, IssueDateTime....
Site Name
Printer, IssueDateTime....
Printer, IssueDateTime...
Site Name
Printer, IssueDateTime...
Printer, IssueDateTime...

If I do a crosstab query, then I have to add or count the number of entries for each site name per day (DateAdded) but how can I include the detail of each entry?


0
hnasrCommented:
Supplying Input, process, and output  information reduces the explanation and leads to a quick solution.
ex:
a  b  c
1  2  3
1  2  4

process: a+2, b-1, c*2

Output:
a+2   b-1   c*2
3      1       6
3      1       8
0
dlmazAuthor Commented:
Thank you for your time. I'm going forward with using a crosstab query (spoke with user today and he'll accept this format).
0
dlmazAuthor Commented:
Snapshot is final output that was acceptable by user - thank you.
Snapshot2.jpg
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.