Search results

I literally meant the first 25% of the records. If I had 100 records it would be 1-25. I've already put the records in order according to value. Now I need to add colour. This is my code so far: Private Sub Report_Current() Dim Top As Long, MidTop As Long, MidBottom As Long, Bottom As...

How do I format: First 25% of records - Gold Second 25% of records - Green Third 25% of records - Yellow Fourth 25% of records - Red Please!! :banghead:

I just spoke with my boss and apparently he needed the ranking in order to do a calculation that I've already mastered without having to rank. Therefore, Rank is no longer required. Just that efficient... ;) haha Thanks guys

VBA for Ranking - Help adjusting code PLEASE Hello, I have a query I need help with. My query has a variety of statistics for each employee. There is a field in my query called KPIMiss which takes each KPI(Statistic) and gives them a percentage that it's worth, then subracts that percentage...

Ok Kelly, I've been there for sure. 1. Create a new module. 2. Paste that code in it. (Courtesy of help on this site) ;) 3. Create all your queries with the data in seconds. (Do not average) 4. Create your reports. 5. In the text boxes in your report you're going to do something like...

Hi again SmallTomato! Jdraw: You're right, the db design should accept it. It's just too bad they didn't tell me when I built it! grrrr... haha I'll find a way. It turns out that the max anyone has called in about on one escalation is around 6 different products. Worst case: add 9 more...

Hello jdraw, nice to see you again. My db is for a call center. This particular database is for a large world wide department store. Any time a customer has an issue with anything at all they call a certain number and get our center. The agent then takes the info from the customer and puts it...

My db does the exact same thing including a full scorecard. My solution to this problem was a function that puts the time into hh:mm:ss format. I'll post the code below for you to create your own module with, once you have the module you can use it in your reports AFTER YOU AVERAGE if averaging...

Hello, I've been doing some reading on multivalue fields and it seems to be exactly what I'm looking for. My question: Is there a way to use the multivalue field without making it a lookup? I need the user to be able to put multiple values in a field but can't limit them to a list. The...

I wonder if I could work my filter criteria into the text boxes of the report itself...

Thanks SmallTomato... That's not what I was hoping to hear, but exactly what I expected to hear. :) I wonder how I managed to do it before... :S haha

Day 4 with no responses, should I assume this can't be done? :(

I've done this once entirely by accident and can't seem to duplicate it... I have a report. It has the following: Report Header: Logo and title Department Header Supervisor Header Group Header Detail Department Footer: Totals Report Footer: Overall Totals for all departments Here's my...

Thanks SmallTomato! Transfers are treated a little differently, but yes, I may end up with two records for the same person. Thing is, if the transfer from dept has an agent status of "Transfer" then they won't show up in the site wide database under that department at all so it will work fine...

Jdraw: Eventually a corporate approach may be the answer, but the departments still need their own databases because it is only the agents table that is common. Each department has many requirements within their own database. Some are similar, but only tblAgents is exactly the same as the...

Small Tomato was right. I'll try a Union and let you know. jdraw: I know it looks like a design problem, but where each of the identical tables come from different databases please tell me I didn't do this wrong... Each department has the exact same info for each agent in their own...

Hello, I have multiple databases (one for each department). All 4 databases have an Agents table (tblAgents). Now I am creating another database that uses all of the agents on site. What I want to do is link all the agents tables and combine the values in one query. Fields are: UserID...

I figured it out... I wasn't referencing the subform in the Navigation Form in my query criteria that looks at the combo boxes. :)

Hello! I have a form with a sub report. The form has very little on it, just combo boxes that filter the report and the report is below them. The parameters for the filter work great while the form is open and filter the report perfectly. When I open the form it works great and does exactly...

Dave, Does that mean that access can't tell me what field the value came from? Right now this: LowestValue: Minimum([Field1],[Field2],[Field3],[Field4]) = 21 Isn't helpful at all without the name of the field. I can do something like the following in a separate query field...