Search results

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...

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 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

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...

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]) *...

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?