Access 2003, Need Report To Show Total Count
Thank you for taking the time to report an issue.
What's wrong... Please write below.
This kind of works ok apart from still returning avalue of 1 when no records show up and that it's just a clumsy work around so could anyone give any help on how to do this better?
Also I'm looking to have reports as normal but also the option to just view a summary form with only what criteria has been used and a total record count so help with this would also be very much appreciated.
Oh one last thing, is there any way to change a report title based on criteria used, I.e. I want a report title to be "Total Outputs between [Start Date] and [End Date]" or something along those lines.
Report to show the following:
Month | Count Expected Shorted Over
Jan | 100 | 200 | 100
Feb | 250 | 200 | 50
Mar | 50 | 200 | 150
Yearly Total: 400 | 200 | 250 | 50
Count is the number of appointments scheduled for a month. I know how to get the calculations done. It is showing the constant data that I don't remember how to.
Would it be best to query the data for a count and then actually place the above data on a worksheet in Excel?
I need to show by COMPANY the Total count of DECISION CODES and of those the Total count that were "REJECT".
I would then like to take the Total Reject and / Total Number for a percentage.
Company Description Total Count Reject Count Percentage
Example: Acxiom 123acx 1,273 53 4.16%
I havn't used Access since 03 and am trying to get back in the saddle
however this is simply giving the total count including all the blank entries.
There is space for it (The second column ends about half-way down the page). How do I get the record count total to display under the last record listed instead ofa new page?
sum price total
1 $10 $10
0 $5 $0
2 $2 $4
what I'd like is for a grand total to be shown in a report or at the bottom, for this example, $14
the total column is made with a query, multiplying price and sum sum is also a query, adding up the total amount of different stock
currently I had to re-format my total column Total:Format(price*sum),'currency'
When I have tried to do this, I clicked the total button, but my only option is for a count, I need to sum the values, not count how many there are. I am pretty sure it is because the totalcolumn is not actually a price format
I could also just have a report that lists this grand total, but I came up with the same problem.
What is easiest way where I can run the report showing three variables (Total Count, Total Count of Males, and Total Count of Females) based on user input for date range provided.
EntryDate is date column in table.
Sex is the column where Male or Female is stored as text
Total number of current clients .XX
Total number of current male clients .XY
Total number of current female clients. YY
Total number of discharged clients.ZZ
plus a few more totals
I have made queries for all these but how do I get a total figure to appear in a report?
I know this might be a simple process but I cant get my head around it. Have tried sum and count in the query, but should I do this in the report?
This is a detail report that reflects [Card Number] and [Amount] so at the bottom I have a total transaction text box that works fine.
I would also like to capture the total [Card Number]. However, since the same card number can show up several times, I don't get the actual count.
Can you count just the unique records in a report from a text box?