simple query question - totals & ytd percents 1

[gimpy0821]

I've been away from Access for so long - I'm embarrassed. I need a simple query that will create totat count of 1 grouped field and the total ytd % of all records in table.

Anyone have a sample? Thanks

 

[lameid]

I don't think anyone can tell whay you mean by ytd %.

Your table name and field names would be helpful.

There is an Access queries forum where this would be more on topic.

 

[gimpy0821]

I have a table where each row has a unique ticket # that is submitted by a user (EnteredBy). I want to generate a total count of all tickets for EnteredBy and what percent that count is of the total record count of all tickets.

Report would would have a group total for each user as well as their percent of the total tickets:
"EnteredBy" "25 tickets" "100 tickets" "25% of total tickets"

Grand total of tickets at end.

 

[lameid]

I would blend a query and report solution together for this.

Select EnteredBy, Count(Tickets) As TicketCount
From table
Group By EnteredBy

Save that query and then make a report based off it.

In your report footer make a textbox whose control source as below

=Sum(TicketCount)

Name that text box txtTotalTicketCount.

In your detail section you will have controls for EnteredBy, TicketCount.

Your percentage can be found with the below.

=TicketCount / txtTotalticketCount

txtTotalticketCount is of course your grand total at the end.

 

[gimpy0821]

Thanks works like a charm!