Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. everest

    How do you fix the length of Excel cells?

    I have this excel file that needs to be formatted for some old fortran program. In excel, it looks something like this: Site Atim Zo VS ----- ----- ----- ------ Main St. 60.00 0.00 0.00 1st St. 20.00 0.00 0.00 Washington 80.00 10.00 10.00 The...
  2. everest

    Selecting Time Ranges with Excel VBA

    Hi, I'm pretty new to VBA and I've got this problem with some data I'd like to format. The data is formatted like this: Date Time Value 2/10/04 22:00 25 2/10/04 23:00 26 2/11/04 00:00 27 2/11/04 1:00 28 2/11/04 2:00 29 .... 2/15/04 1:00 30 2/15/04 2:00 31 The data continues for several more...
  3. everest

    Word 97 Caption Numbering Question

    ...example, I have a Figure 2, then it goes to Figure 5, then Figure 8, etc. The field codes for the captions are all the same. It's {SEQ Figure \* ARABIC }. Maybe there's something wrong with my field code? Or it could be some bug in Word 97? Has anyone ever run across this and know of any...
  4. everest

    UPDATE query within a query possible?

    Thanks for your help Mike. That did the trick.
  5. everest

    UPDATE query within a query possible?

    ...B-2 Iron 10 B-2 Lead 10 Table 2 Element Total2 Iron 6 Copper 2 Calculate Percent field using LEFT JOIN and(Total2/Total)*100 AS Percent ON Table1.Element=Table2.Element Joins into Query 3 Query 3 Site Element Percent A-1 Iron 60% A-1 Copper...
  6. everest

    UPDATE query within a query possible?

    Hi, I have query that join two tables together. Table 1 Site Element A-1 Iron A-1 Copper A-1 Zinc B-2 Iron B-2 Lead Table 2 Element Percent Iron 60% Copper 20% Joins into Query 3 Query 3 Site Element Percent A-1 Iron 60% A-1 Copper...
  7. everest

    Transposed Query Question

    The data in the transposed table needs to be unique/individual data points. To get around this, I just checked (counted) to make sure that each date has only one instance of a chemical/element. Then I just use a max,min, or average. Should return only one value for that field. I used the...
  8. everest

    sorting individual columns.

    Hi, I have an excel question regarding sorting individual columns. I have data in such a format Iron Lead Zinc 0.5 0.3 0.2 0.1 0.2 0.1 0.2 And I would like it to be in this format Iron Lead Zinc...
  9. everest

    Transposed Query Question

    Hi, I have a question about querying environmental data so that it is transposed (sort of). I have an Access table with three fields, Element/Chemical, Date, and Result. For example, I have: Element Date Result ------- -------- --------- Iron 2/1/03 10...
  10. everest

    Excel-comparing datapoints to a criteria (Dcount or Vlookup)

    Skip and Ken, Thanks for your help. I have been running the comparison using Skip's method before I posted the question. I would make a criteria for each pollutant and then modify the previous Dcount formula. It was just getting to be very repetitive manually entering in a criteria for each...
  11. everest

    Excel-comparing datapoints to a criteria (Dcount or Vlookup)

    I may have asked this question before but I can't seem to find the past post. I have some water quality data to compare against government standards. Out of a dataset, I need to get a percentage of how many datapoints exceed the standard. Right now, I'm doing this with the Excel function...
  12. everest

    USB 2.0 External Hard Drive Problems

    I put together an external harddrive using a Coolmax enclosure and a Maxtor 120GB drive. It was working fine before, but now the transfer rate has gone down significantly and sometimes freezes or stops in the middle of transferring large files. I'm just wondering if anyone has run across a...
  13. everest

    Importing excel to access with single quote problem

    That works. Thanks. I actually saved it as a .CSV file and that got rid of the single quotes. Just did a cut and paste back into the .XLS file. Thanks again for your help.
  14. everest

    Importing excel to access with single quote problem

    I tend to leave out some important details in my posts. In the time field for the Excel file, there are some fields that don't have single quotes in front of them. I'm thinking that Access doesn't know what to do when it sees some with quotes and some without. It just sends these fields to...
  15. everest

    Importing excel to access with single quote problem

    Hi, I asked a question a few weeks/days ago about removing single quotes. I've tried the advice given to me but with no success. I've imported a spreadsheet from Access to Excel. In the Excel spreadsheet, there are single quotes at the beginning of every cell. At the time, the single...
  16. everest

    Removing single quotes when importing Access to Excel

    All of the fields are text data types. I noticed that the numeric ones don't have single quotes.
  17. everest

    Removing single quotes when importing Access to Excel

    I'm guessing that data type means the format of the cells? I have all of the cells formatted to General. This single quote appears. Please correct me if I'm wrong. After playing around with it, excel seems to ignore these single quotes when performing calculations which was my biggest...
  18. everest

    Newbie Advice on doing comparisons in Access (VBA or SQL)

    Hi, I have a project that requires me to compare bunch of water chemistry data with certain limits. I might have 10s or 100s of data points for a certain chemical and I need to get a percentage of data points that exceed the limits. For example, I might have five data points for mercury that...
  19. everest

    Removing single quotes when importing Access to Excel

    Well, I'm using Access 2000, and on the screen/window that lists all the tables you have in the database, I right click on the table that I want exported to Excel97 and I click on "export". Then I just save it as an excel file. I hope this is detailed enough. Any help would be...
  20. everest

    Removing single quotes when importing Access to Excel

    Hi, I have a spreadsheet that I've imported from Access to Excel97. In the excel spreadsheet, I keep getting these single quotes in every cell. I've tried running a replace to delete these single quotes, but it doesn't work. Does anyone know of a way to get rid of these single quotes...

Part and Inventory Search

Back
Top