Is this possible...

[JediYodaNT]

Hello everyone. I have a report question. I have become our department's resident tech support person, and as such, I'm now becoming the Access guy...via trial by fire.

We have a database that is used to enter work items that are processed each day by each of our associates. It is used as a tool to track productivity numbers. The associates can process any one of 20 different processes in a day, and will need to enter each transaction into our database.

What we have been using to track numbers, has been tedious and time consuming, and I'm pretty certain there has to be a way to get Access to assist in doing this.

What I'd like to create is a report that will group processes by associate name, then in more of a table view, provide me with a row of dates along the top, then under each date I'd like it to show me a total count for each process completed by that associate each day. Do you guys think this is something I would be able to do, or am I asking more of Access than is possible?

My Goal:

Associate 1 5/4/09 5/5/09 5/6/09 5/7/09 .....etc

Process 1 5 7 6 2
Process 2 1 0 9 6
Process 3 4 13 1 8
​

Associate 2 5/4/09 5/5/09 5/6/09 5/7/09 .....etc

Process 1 9 8 4 1
Process 2 8 9 8 4 etc
​

 

[Mr. B]

JediYodaNT,

The report you desire is certainly something that Access can do.

With that said, the amount of work required to get it functional will depend a great deal on the structure of the data. It will also depend on your skill level in creating Access reports.

I wrote an application a couple of years ago that had a form that produced some results very much like what you are describing. See the attached file. There was also a companion report of this data, so I know it can be done. This one required a good deal of coding.

HTH

 

[JediYodaNT]

Thanks Mr. B. I wanted to make sure that this was a possibility before I continue to spend time on research, only to find out later that it was not possible.

 

[DCrake]

The bases of your report will be a CrossTab query. Using Associates and Processes as row headings, dates as column headings and occurances as the data you are analyising. Very similar to pivot tables.


David

 

[JediYodaNT]

Thank you both for your replies. Reading your reply, DCrake, makes it quite obvious to me that I am going to need more advanced training than what I have found to date. Can you guys recommend a site that would provide some in depth tutorials on the more advanced techniques for crafting reports? Access is a new project for me, and the only training I ahve received was from Microsofts online tutorials. These did not get into the more advanced tools and techniques. This is the beginning of my 3rd week working with this database, so I now I still have a long road ahead of me.

 

[Mr. B]

JediYodaNT,

Actually, creating the crosstab query that DCcrake is describing is not so bad. Use the Query Wizard and it has an option for creating a crosstab query. When I said that there was quite a bit of programming involved in the one I described, I was speaking about the Form that the data was being displayed on and that was only due to the fact that they want some special functionality in connection with the data.

Just give the crosstab guery a try using the Wizard to create it.

HTH

 

[JediYodaNT]

Awesome. I'll give that a try this afternoon and we'll see how things go. Thanks again. You guys are great.