Recent content by mkuethe

Thanks for attempting to help, but I have it figured out... ="0"&LEFT("0"&TEXT(A1,0),8)&MID("0"&A1,11,2)&MID("0"&A1,9,2)&RIGHT("0"&TEXT(A1,0),2)&"00

I've been struggling with this for a while and desperately need someone's help. I need a macro that will take a 13 digit number, add a zero at the front, change the place of the 9th and 10th digit and then add two more zeros at the end. For instance: Take 08347004003486 in Column A and change...

I've been struggling with this for a while and desperately need someone's help. I need a macro that will take a 13 digit number, add a zero at the front, change the place of the 9th and 10th digit and then add two more zeros at the end. For instance: Take 08347004003486 in Column A and change...

I want to export a query from Access to Excel and then analyze the data. What I'm pulling into Excel is data with 31 columns. (30 are audit questions and the last is the name of the person being audited.) Row 1 is a header row, showing each question's description. (i.e. Greeting, time...

That worked! Thanks!

I'm struggling with an Excel spreadsheet that contains 91 rows. What I’m trying to do is: Sum all rows in Column G when Column B=.0001 and Column E=1 within the same row. In other words, only add cells in Column G if, within that same row, Column B=.0001 and E-1. Make sense? Can anyone...

SELECT Tbl_Main.ContactID, Tbl_Main.[Consultant Name], Tbl_Main.[Company Name], Tbl_Main.[Date of Service], Tbl_Main.[Date Audit Completed], Tbl_Main.Auditor, Tbl_Main.CFMI1, Tbl_Main.CFMI2, Tbl_Main.CFMI3, Tbl_Main.CFMI4, Tbl_Main.CFMI5, Tbl_Main.CFMI6, Tbl_Main.CFMI7, Tbl_Main.CFMI8 FROM...

Yes, that's what I need. Can you walk me through setting up the summary and the check box command?

Yes, there is a table (tbl_score) that the question scoring combo boxes pull from. We want it scored per audit. We have auditors that review others' work and answer 8 questions (MI1, MI2, MI3, etc.) Based on the work, the questions are either "1" (Yes) if that indicator was met, "0" (No) if...

I have a form that lists 8 audit questions that are scored 1, 0, -1 (Yes, No, N/A) using combo boxes. What I need is a query that will count the "1" scores and mark a check box as true if the result is 3 or greater - excluding the No's and N/A's. Can anyone assist???

Got it - It worked! Thanks so much!!!

Yes. I've tried formatting both as percentages, both as numbers with decimal places, nothing works. That's why I'm struggling so much. I can't figure out what I'm doing wrong.

I tried that, but obviously I'm doing something wrong. Here's my scoring scale: 100.00% 5 99.80% 5 99.79% 4 99.50% 4 99.49% 3 99.00% 3 98.99% 2 98.50% 2 98.49% 1 0.00% 1 Any percentage I'm putting in is returning a "#NA" with the exception of 100%, which is returning a "1". I've tried...

I'm creating an employee performance database and need to know how to assign a score dependent on a percentage. For instance, if an employee achieves between 99.8% and 100%, the score should be "5". If the employee achieves between 99.5% and 99.79%, the score should be "4" - and so forth. The...

For the last couple of weeks, IE stalls everytime I go to a new web page. The page will load, but I have to wait approximately 20-30 seconds before I can click any links. This is getting extremely frustrating, since I'm working on a LAN and am use to almost instant page loading. Anyone have...