Search results

I'm trying to use the COUNTIF formula and count up information on several different tabs. However, it keeps giving me the #VALUE! error. This is the formula that I have: =COUNTIF(East:West!F:F, Sheet8!A4). There are five tabs in the workbook that I am trying to count up. Do you know how I...

I found a solution to this problem. By just adding an additional IF statement, I got it to skip the first call for each site. =IF(N2=N3,IFERROR((INDEX($Z3:$Z$1000+$AA3:$AA$1000,MATCH($N3,$N3:$N$1000,0))-($AB2+$AC2))*1440,""), "") Thank you so much for all of your help.

The cell format is general.

This is great. I just have one problem. For some reason, it is not showing a blank when my site number changes. Instead, it shows a huge negative number (i.e. -39259). Do you know why that would be, and how I can correct it? Thank you so much for your help. I really appreciate it.

This is formula (=(LOOKUP(2,1/($N:$N=N2),$Z:$Z+$AA:$AA)-INDEX($AB:$AB+$AC:$AC,MATCH(N2,$N:$N,0) ))*1440) is really close. The only problem is that it calculates the number of minutes between the first and the last call, and there could be several calls in the middle that are not calculated...

Will that take into consideration if the calls are several days apart?

I have a spreadsheet that lists service calls for one of our customers. That customer has several locations that my company services. My manager has asked me to set up a formula that will calculate the time in minutes between service calls for each location. My spreadsheet lists the location...

I have a very large database (over a million records). As a result of the size of this database, it is very slow. I've done everthing I can think of to speed up this database, and nothing seems to work. I've compacted and repaired it. I deleted any fields that were not used. I made sure I had...

I have a couple databases that were created a just a month or two ago, and are already over 1 million records. As a result, the databases are really slowing down. I read somewhere that you can house the backend of a large Access database on an SQL Server. I was just wondering what steps I...

Thank you for all the assistance you were able to provide. I just thought I would post back and let everyone know what I was able to come up with. The site I was referencing, had a comma delimited file that could be downloaded. I used the address for the comma delimited file and changed it...

That worked perfectly. Thank you very much.

I am trying to set some variables in VBA so that I can add them to a URL for a Active X control. However, the debugger keeps telling me that "an object is required". I don't understand what it wants. If someone could help me, I would really appreciate it. Here is the code I am trying to use...

I was just wondering if it is possible to program Access so that it will go to a website, enter search criteria and then copy the resulting data. I have recently been asked to track the weather condition in cities where my company's equipment has problems. The website that I found to...

I have a table that can have multiple records for one piece of equipment on the same date (depending on the number of transactions involving that product). The data in this database is pulled from reports sent in directly from the equipment. If the equipment has had many transactions on one...

That works great! Thank you very much for your help.

They are in multiple columns.

Is there a way to resize the lables of a Line Chart? I have a line chart showing the actions taken on a piece of equipment. My only problem, is that sometimes the label can be quite lengthy. Instead of wrapping the text, Excel just stretches the label, causing it to run into other labels. I...

I have a spreadsheet with all the service calls for a given customer and the call texts that the technicians entered for each call. The only problem is that the call texts are separated out by line. In other words, one call may have multiple lines of text, and thus the call number is repeated...

That worked perfectly. Thank you very much.

I have a memo field on my form that was imported from other software where a service tech enters the details of what he or she did on a call. The way that field is formatted in the source file, is that it uses ^ instead of line breaks. As a result, when that field is imported in to Access for...