[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

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?
0
dlmaz
Asked:
dlmaz
  • 4
  • 3
  • 2
1 Solution
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now