Search results

I think I found the reason. For some reason when I import the new data(april) their previous months user data(february) is getting overwritten with the new data, but only for those 4 users.

i have setup an outer join but seem to have the same issue. i believe the issue is coming from the table that is between user info and statistics, which is usernames. The user info contains their basic contact info. Statistics contains their stats for that month. The table between them is a...

So the users table has 33 individuals. When I run my query it only pulls 29 individuals. I have found that the reason is because in 1 table 4 users dont exist because they have no records or statistics in that table. My join is already set to show all users in the users table and matching...

I'm using two forms to open a report. One form contains the Supervisor and Month. The other form is user specific information. Criteria currently using: Forms![frmScorecards]![Month] or Forms![frmUser]![Month] Now when i run the report from frmScorecards it asks for the parameters of...

Basically I have a report pulling individuals average talk times on a phone. Depending on their time we associate a Rating. On Report_Open I was trying to set a IIF ([AvgTT] > "85"), AvgTTlbl.caption = "Exceeded", AvgTTlbl.caption = "Partially Exceeded" According to the AvgTT properties its...

The database contains a table with users. Each table has different fields but that table exists 12 times (one for each month). The reason we are using 12 versions of 1 table is at the end of the year we can run a yearly report on that statistics. This way each month has its own tables.

That explanation is pretty poor. I am looking to have one query setup to calculate all the totals per user. Since the totals change every month I am trying to come up with a way that when the query runs. It asks for a month, when the user inputs the month, the query will change to the input...

I have a database with 96 tables. 8 tables per month one query pulls the desired information. My question is this, currently the query looks to all the January Tables. Can I configure one query to request user input(month) and then the query looks to the tables based on the users input(month).

I figured it out. Just used a Simple Amount: SUM(IIf([Name]=[Name],1,0)

I have a spreadsheet and the only column that matters is D. Down column D it appears as: a b b b c c d e f c a I need the result to just appear like A - 2 B - 3 C - 3 D - 1 E - 1 F - 1

Anyone know the SQL i could place in the query to pull 99.02 where name = total?

Below is what my tblAdherence looks like in Access: My query returns results like so: Name | Adherence Doe, Jon | Total | 99.02 So when I run my query based off names associated to divisions it only pulls names within that division...

Wow, you're right. Can't believe I was missing that. I was trying to round the whole code. Thanks!

My sql code reads as follows: Total ATR: Round([Total Resolved] / ([Total Resolved] + [Total Escalated]) * 100) & "%" This will round to a whole. When I try to set it to round to the tenth it fails. I tried using Total ATR: Round((([Total Resolved] / ([Total Resolved] + [Total Escalated]) *...

oh yah, should of figured. thanks again

Another quick question. I have ATR displaying as (Resolved / (Resolved + Esclation) * 100) for a percentage. How can I add % to the end of the results?

I actually changed it to SELECT Table1.User, Sum(IIf([Table1]![Escalated]="No",1,0)) AS Resolved, Sum(IIf([Table1]![Escalated]="Yes",1,0)) AS Escalated, ([Resolved]/([Escalated]+[Resolved])) AS ATR FROM Table1 GROUP BY Table1.User; And it worked perfectly.

boblarson, id like to see your ouput but i keep receiving errors for some reason Code: SELECT Table1.User, Sum(IIF([Escalated]="No",1,0)) AS Resolved, Sum(IIF([Escalated]="Yes",1,0)) AS Escalated FROM Table1 GROUP BY Table1.User;

Ok so I am attempting to create a simple count query and have had some issues. The table looks like so: and I need the query to display the count for user: Nick, no and yes. So the result would be: Nick - Yes - 2 Nick - No - 5 and so forth for each user. Is this possible in one query?