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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gearhead03

  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

Part and Inventory Search

Back
Top