What should be better, Acces Aplication or Report?

[alanjgamino]

Hello and thanks for reading this, I have a doubt and as i am new to access but know some programming, I want to know what is the better more practic way to solve this, I have a database that needs to be sorted, on the 4th row i have a number for certain transactions, i need to count all of them and have the total per each kind of transaction, but i need to establish a start date and end date witch is in the 7th row, thanks, I will aprecciate any help.



1 2 3 4 5 6 7
110155.00 300.00 2 1201002300 27 1551 15/09/2012
119487.00 1000.00 2 1206002300 27 1551 17/09/2012
160062.00 6000.00 1 1001000100 27 1551 14/09/2012
160062.00 2360.00 1 1101000300 27 1551 12/09/2012

[HMEpartsmanager]

I would have a query setup the way you want it; sorted by the 4th row, and then by date. In your query, you could put in a question to ask you what date range to use as a criteria. Now the data is ripe for the report. Have the report do all of your totals.

When you run the report, the report would grab your query, and that query would ask you what date range, and then produce the report you want.

Is this what you are going for?

[alanjgamino]

I would have a query setup the way you want it; sorted by the 4th row, and then by date. In your query, you could put in a question to ask you what date range to use as a criteria. Now the data is ripe for the report. Have the report do all of your totals.

When you run the report, the report would grab your query, and that query would ask you what date range, and then produce the report you want.

Is this what you are going for?

Thats what im going for, thanks much, I will start the query set up, will post advances. Thanks again

[alanjgamino]

Thanks for your help, I already have the query set up and everything looks good, now on the image below on row #2 these are the kind of transactions a customer is making and there are 46 types divided in 7 groups, for the report is there a way I can only display the seven group names and the total of transactions made by the sum of the cells on row #3, thanks much

[HMEpartsmanager]

Alan, I believe you meant 'column'? Column 1 has a date, column 2 has the kind of transactions, and column 3 has the total count of that transaction type on that date; is this right? I ask as I don't see any duplicate entries in column 2.

When you create your report, you will give this query to it, and then you can have it 'grouped' by the "SEVEN GROUP NAMES", while allowing it to tally the totals for you. The report functions can do a lot, so you should be able to create the report and have only the group names on the output. I have similar reports here where I have detailed reports, reports with only sub-categories, and even some reports that do what you are going to do and that is to only summarized the major categories.

Have you started trying to make the report? As you create the report, you can set up these groups on how you want it separated out. You want to review the section on Sorting and Grouping.