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...
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
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...
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...
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
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...
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
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...
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...
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...
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
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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.