Is this possible?

[KristenD]

I am working on the second half of my database and I want to make sure before I promise the manager that I will be able to do a report in Access that I currently do in Excel.

Currently in Excel I have a report run from our Payroll system which is then dumped into Excel and then I have to do a compare on two other spreadsheets in order to get the what I hope is the correct data in there before sending it off weekly.

The reason we created this database is to streamline our Resources information so that it resides in one place rather than 3 or 4 different spreadsheets and it takes me an inordinate amount of time updating several spreadsheets from one email Anyhoo, totally got off topic there!

I would like the report to be similar to what I have created in Excel where it separates the employees by job and (the rest I know I can do by group and sort) then total each job separately then total everything and also create a chart in the report as well. Is this possible to do in Access? I know the breakdown and stuff is possible I just want to make sure that the totals will work out as well as the chart. Also I have percentages worked out at the bottom as a summary as well.

Let me know if you need to see the Excel report.

Thank you!!

 

[plog]

I want to make sure before I promise the manager that I will be able to do a report in Access that I currently do in Excel.

I've retyped this a few times, but it always sounds like a put down, but that's not my intention. Here goes:

Most likely Access will be able to accomplish what you want, and even make the process easier. However, that doesn't mean you will be able to get Access to do this. My point is, its all about your skill level. If you don't know have a good idea of the specific steps you need to convert your Excel system to an Access system, then its going to be difficult, maybe impossible for you. Given that you are asking this question leads me to believe that you do not have the skill necessary nor know the specific steps needed.

However, that doesn't mean you can't acquire those skills. If you want to muddle through this project and learn as you go, feel free. If yu have any specific questions post them on this forum and I and others will be happy to help.

 

[KristenD]

I do not take it as a put down. I am most definitely a beginner in Access and slowly making my way towards an intermediate user. I don't want to convert the Excel into Access as most of the basic info is already in the database, I am just adding another portion (well 3 portions to be exact). I realized after going through some of the reports that I have for the other portion that I have already done the totalling portion of the report and know how to do that.

I figure as long as it is possible, I can and will figure it out eventually!