Search results for query: *

I receive daily invoice paid/process reports from a third party vendor, so there is little hope that they will change the format of their files. I simply would like to read the .txt files in Excel. When I copy and paste the data, and use the Text to Columns function, there are serious format...

I have a set of 6 numbers: 500 400 300 200 180 150 If a cell equals any of the above numbers I want the cell value to be multipled by .56 if else, multiply the cell value by .185 I am having issues with the embedded is statement. Should I add another column and try using a lookup (using a...

First let me start off by posting, I'm an idiot. All I want to do is create a custom format that leaves positive percentages black and formats negative percentages with ()'s and formats the font red. The current type #,##0.0_%);[Red](#,##0.0%) Is not working for the postive numbers. Thanks...

I know there is going to be a simple formula response to this but my brain is too focused on the holidays to come up with a solution. I have a spreadsheet that contains rates in about 10 columns. I would like to add a column at the end of the spreadsheet that returns the lowest value...

Good Afternoon, I have a very simple db which is comprised of mostly deadlines (dates). I have a query that pulls all events within a certain date range. Is it possible to export the query data into a calendar like the template in Word. Or are there any other recomendations? Thank you

Using Adobe Acrobat Standard 6.0 - I would like to delete or at the very least paint over a image/logo in the upper left hand side of each page in my pdf file. Currently, I am trying to use the Touchup Text tool to select the image and simply delete it. However it is not working, I realize it...

Good Afternoon, I have a phone report from notepad. When I paste the report into Excel, the time of call column is automatically formated as time of day. Example: 2:48 (as in 2 minutes & 48 seconds) shows up as 2:48 AM in the formula bar. Any ideas how to format this so I can run calcs of...

Good Morning, On Sheet1 there are two columns one has the date and the other contains amounts. There is an amount for every business day for the last 3 years (Example below): Column A Column B 2/1/2003 322.5 2/2/2003 445.2 2/3/2003 299.6 I would like to be able to sume the amounts by...

Good Morning, I have a file with over 6,900 rows that originated out of Fox Pro. The issue is that the unique identifier (Store #) is in a row above the data and the part numbers are in row(s) below the Store #. The amount of parts differs for each store. Example Row 2- Store 17 Row 3 and...

I have a column of data with account numbers, most contain a letter or two in them. Now, the number of characters in each account number vary from 8 to 30. The text included in the account numbers are not set at a specific space, i.e the first character or the 7th. Is there a way/formula that...

I have created a simple DB to house work projects. This db will allow me to track all current open issues as well as everything worked on and completed within a certain time period. Right now, it has only one table. I am looking for suggestions how to break up the data. All of these work...

I ran a query and dumped it into Excel. One of the Columns is labeled "Remarks". I want to count all records/rows where a certain word appears in the "Remark Column". Since there is a couple of sentences in each cell, I can not use a straight If or countif formula. Any...

I have a very simple select query: SELECT tblMaster.[Utility Company], tblMaster.[Contact First Name], tblMaster.[Contact Last Name], tblMaster.[Office Phone], tblMaster.[Cell Phone], tblMaster.Fax, tblMaster.Email, tblMaster.[Company Web Page], tblMaster.Comments FROM tblMaster WHERE...

I had a db replicated with the Design Master on my C: drive and the replicate on the network. Being the genius that I am, I managed to delete the Design Master. I used the Tools- Replication - Recover Design Master and it recovered the replicated db as Design Master. So now there is just...

I am just attempting to count all cells that have data in them. Both the countif and count a formulas are only counting those cells that begin with a number, not those that begin with text. I am currently using the following formula...

Good Morning, I have a couple of very large txt files (phone records) that I am attempting to import into Access. These files have no header row. The fields that should be named "Number called from" and "Number called to" are simply phone numbers with no dashes or ()'s...

I have two tables- tblStore has all store information. tblAddress contains store addresses (pretty clever, I know). I want to create one master table so I can remove the Address Subform. The select query I use now links the table by StoreNumber but does not return all the stores in the...

Good Morning, The scale (Y-Axis)for a few of my charts in Excel 2000 dips into negative numbers. However, this seems to pull the labels for the X-Axis up into the plot area? Any ideas how I can prevent this? Thanks, Cord

Background- 3 tables populate a form and two subforms. I attempted to use an Append Query to dump all of the data into a Master table. The primary key is "StoreNum" and it is spelled the same on all 3 tables used in the query. When I run the query, I receive the following Error...

I know it is possible to add a command button to open another Microsoft application on a form. It is possible to have the app open a specific file? I would like to add a button that opens up an Excel Template. Thanks, Cord