Search results for query: *

I have a spreadsheet where I have data such as shown below: Name Case Date Number John 123 01/01/2016 ABC12345 Judy 567 01/02/2016 DEF56789 Jo 912 01/15/2016 HIJ12345 Jo 789...

I have no idea how to do what I need. Excel is probably not the best place to do it, however, everyone in my office has excel so that is where I was hoping to get it accomplished if possible. Any help anyone can give me would be greatly appreciated! I have workbooks where I am tracking some...

I am trying to format a report that shows the length of time an action took. I want the format to be in hours:minutes:seconds (00:03:37). I can get the cells to show this, but the formula bar at the top show 12:03:37 a.m.). This confuses the users. Is there anyway to get the bar to actually...

I have a spreadsheet that has several columns of data, one being a "start date" and one being an "end date". I want to be able to take look at this data and say how many records were eligible for a specific month, without having to list each month. Below is a small sample: 12345 Smith...

I have a list of records - about 5,000. Each record has 4 fields. The list of 5,000 is not unique, but I want to make it unique. I can't just filter the list because I need to review each record and see which one to delete (there are 2 fields that could be different on each record). The only...

I am not sure that Excel is the best place to do this - but I seem to be able to figure things out in Excel better than Access. I have a list (A) that has ID numbers and dates of service. Each date of service also has a provider number. I have another list (B) with the same ID numbers. This...

Hi. I have a long list of numbers (actually formatted as text). They should be 9 digits long, but they all have an additional leading zero. Some of the numbers should have 2 leading zeros, but have 3, and some should have no leading zeros but have 1. Ultimately, what I need is for the...

I have a list of doctors and their patients. I also have a form I need to fill out for each doctor with the patients' names and dates of birth. I only want to send one form to each doctor. I'm sure there is a formula, I'm just not sure how to do it. I have the doctor's names at the top of...

I have a spreadsheet in excel that I imported from another program. It is a list of client identification information and # of medical visits. If one piece of the identification information changed from one visit to another, then there are two lines for that client. However, any of the pieces...

I know this is a really basic question - but I can't find the answer. I have a database with 2 tables. Table A has the following fields: Original ID, Visits, Allowed (primary key is auto number ID). Table B has Original ID, FQVisits, RVisits, FQNet, RNet, Visits, Allowed (primary key is auto...

I know this is a really basic question - but I can't find the answer. I have a database with 2 tables. Table A has the following fields: Original ID, Visits, Allowed (primary key is auto number ID). Table B has Original ID, FQVisits, RVisits, FQNet, RNet, Visits, Allowed (primary key is auto...

I have a spreadsheet that is set up as follows: ID# Type A Type B Type C 1111111 Value 1 1 3 5 Value 2 $50.00 $25.00 $75.00 Value 3 3 5 7 2222222 Value 1 5 7 2...

I have a query I have run in a database program for claims data. The query has 65000 lines. Each line is for a medical claim tied to a patient's ID number. Each ID number could have any number of lines, depending on the number of claims. I would like to sort the data in ACCESS (maybe?) with...

I have a query I have run in a database program for claims data. The query has 65000 lines. Each line is for a medical claim tied to a patients ID number. Each ID number could have any number of lines, depending on the number of claims. I would like to sort the data in an EXCEL spreadsheet...

I'm not sure I'm putting this in the correct forum...if not, sorry! I have a large word document (4200kb) that I am unable to open. I was last in the document three days ago and there was nothing remiss. Today when I try to open it I get the following message: The document name or path is...

I have a very large table in ACCESS. One field is Claim number, another field is revenue code. Each revenue code has it's own line (or record) so the Claim number is repeated as many times as there are revenue codes for that claim. The revenue codes can be repeated as many times as needed...

I know there are many questions out here about ordering the items in a list box and/or combo box...I'm just not clear on what I need to do. I have a table that has three columns: Answer, Numeric Value, and Type. For each "Type" there are 2-10 different "answers". The...

I am brand new to Powerpoint and seem to have figured it out pretty well, but I want to make one change that I can't figure out (actually, one time I did this by error, but don't know how to re-do it)...anyway, I am using the "Dad's Tie" template, my slides are landscape, the tie goes...

We have a user who is having problems with Microsoft Word. When she pulls up a new document and tries to change from portrait to landscape she gets a message saying "settings you choose for left to right margins, column spacing, or paragraph indentations are too large for the page width in...

I have put a survey on ACCESS. Most of my questions have combo boxes that are used to enter the resonses. However, I do have a couple of list boxes because there are a couple of questions where the clients can answer more than one question. I set the form up with a lot of help from Tek-Tips...