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!

  • Congratulations strongm 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: *

  • Users: gearhead03
  • Order by date
  1. gearhead03

    Will not boot, invalid system disk

    OK thanks for the help everyone! I am back up and running. I checked and changed my boot order and things to no avail. Ran FIXBOOT and FIXMBR (cuz I ain't skeered and I back up) No luck I unplugged any USB drives, no joy. I finally used the information in this thread...
  2. gearhead03

    Will not boot, invalid system disk

    I tried that. Still no luck. It's really strange, If I have the windows CD inthe cd drive, even if I don't boot from it, windows boots up fine. If I take the disk out I get the invalid system disk error. Mark A. Kale
  3. gearhead03

    Will not boot, invalid system disk

    This morning my computer gives me an invalid system disk message and will not boot up. Windows XP Home edition. Ran System Mechanic recovery console and it didn't find any issues with the MBR or Partition tables. Then I put my Ubuntu boot disk in. Ubuntu is NOT installed in this PC. At the...
  4. gearhead03

    Group and Sum in Excel

    Worked Great Thank You! Mark A. Kale
  5. gearhead03

    Group and Sum in Excel

    Thanks Skip! I'll give it a try and check back in! Mark A. Kale
  6. gearhead03

    Group and Sum in Excel

    I have a spreadsheet that on each row has a load number and rate columns. (among others) I would like to have the program sum the amounts in the rate column based on the load number cells being the same. For example if three of the rows have 9595 in the load number column it would sum those...
  7. gearhead03

    Sum a field

    SELECT Checkregister.preclear, Sum(Checkregister.AMOUNT) AS SumOfAMOUNT FROM Checkregister GROUP BY Checkregister.preclear HAVING (((Checkregister.preclear)=Yes)); I would like to make separate queries for deposits and debits based on <0 or >0. Thanks Mark A. Kale
  8. gearhead03

    Sum a field

    Another related question. I would like for it to sum "amount" but less than zero. When I enter the criteria <0 it determines that I want to give the results of the "Sum of Amount" that is less than zero. How do I make it only sum the results that are less that zero in the "amount" field...
  9. gearhead03

    Sum a field

    Great help!!! Thanks everyone! I had copied another query to make this but didn't delete the fields I wasn't going to use, so that was causing the issue! Mark A. Kale
  10. gearhead03

    Sum a field

    I want to sum a field in a query without grouping by week, month, year, etc.... The field to sum is "amount" When I select "sum" on the total line it's not summing all the records in the query, it gives several lines and I am not sure what criteria it's using. what should I set the other...
  11. gearhead03

    Sees drive in BIOS not in windows

    I am running R-studio now. Getting lots of unexpected MFT record.........errors and read disk failed.... Mark A. Kale
  12. gearhead03

    Sees drive in BIOS not in windows

    Okay here are the latest developments. Installed as a slave on Windows XP PC. Windows sees the drive but when clicked on in Windows Explorer it claims that the drive isn't formatted. Making a boot disk with the program from above gives a "Scanning Folder Please Wait" message that has been on...
  13. gearhead03

    Sees drive in BIOS not in windows

    thanks I will try that and update here! Mark A. Kale
  14. gearhead03

    Sees drive in BIOS not in windows

    Wife's CPU locked up last night. A restart would not get past the boot from cd.......... ChkDsk ran about 25% and gave a "corruption error" Installed in different machine with WinME on it as a slave. The BIOS picks up the drive but it's not found in Windows. Booted into DOS and the drive still...
  15. gearhead03

    Formulas used with Sum Function

    I was working on it at the office friday and things got busy. I am working another issue right now. Hopefully later I will be able to address this again. Updates as they develop. Thanks Mark A. Kale
  16. gearhead03

    Formulas used with Sum Function

    I would not be assuming since I am looking at the drivers log book and can add the hours before or after the day off to see if he has a 34 hour restart. Mark A. Kale
  17. gearhead03

    Formulas used with Sum Function

    I am using this spreadsheet to keep track of the hours they drive. If it goes over 70 hours on the sheet that is ok. I have a conditional format that highlights that cell to let me know there is a problem somewhere along the line that I need to go back and look at. What I want to accomplish is...
  18. gearhead03

    Formulas used with Sum Function

    left to right The 1st column is the date The next column is "driving time" The next is "on duty " time The next is a total of "driving time" and "on duty" time The next is a sum of the past eight days "driving" and "on duty" time. The last column just has...
  19. gearhead03

    Formulas used with Sum Function

    Excel 2000. I have a worksheet that I use to keep track of my truck driver's hours to make sure they don't go over. They can have 70 hours on duty in 8 days. I enter their daily "on duty" hours in column "D" and then in column "E" I sum them using Sum(d1:d8) and copy that down the page for the...
  20. gearhead03

    Update 1 table based on a different table

    I have a customer that send me a file once a month. I can import this into a table. It will have about 10,000 records. I need to write a query that will update two fields in each record in my table to the values from the table that I get from the customer. How is the best way to do this or what...

Part and Inventory Search

Back
Top