Recent content by kujito

Denburt over on bytes.com shot me this link. http://support.microsoft.com/kb/209567 Works like a charm

Thanks Mike. I tried searching around a bit, but I wasn't even sure what exactly to search for. I'll try the 'running sum' right now.

First off: (Boss = VP) > (Me = temp./part timer) Boss is 70+ year old geologist, so cpu stuff is not his strong point. He just knows what he wants to see. So, I finally got my queries to output the data I need. Now I'm trying to generate some reports for my Boss. He wants the first column to...

I'll check it out. Thanks

OK. So, here's what I came up with. It took 3 queries to get the different pieces I needed and a 4th query to get it all together. I had to run another seiries of queries for PrimaryMO = 2 as well, so 8 total queries. summaryQuery 1 SELECT Project.ProjectID, Project.ProjectName...

I've got my queries right so that they pull the correct pieces of data I need, but I would like to have a "queryID" field. I'd like to have the query results sorted in descending order based on my totals field. The largest total should be number "1" and the smallest should be, in one case...

Not done, but on track(knock on wood). I needed three queries to get everything to calculate properly. I also need three more (versions of the first 3) to find the same info for mines categorized as PrimaryMO = 1 and PrimaryMO = 2. 'Bout time to go home for the day. I'll try to post updates.

Thanks, I think that's where I'm headed, but I may need more than two queries to get it all. I'll try to remember to post my solution.

Ok, so I have mine production data from numerous years and numerous mines. Some years have 0 (zero) production. I'm trying to come up with columns that display: 1. Total years in operation(good) 2. Years of production(stuck) How do I get a field that will give me a count of only the...

I don't understand your code either, but I see an "If"(IIf=If and only if?) statement without a "Then" statement. What should happen when the "If" condition is met? I'm no expert, but that's what I see. It seems that you need to specify what you want (last completion date?) where neither "Mgr"...

Do you really think I didn't google it?! At least give me that much credit! p.s. solved it on my own despite your help. :)

So, I'm trying to import an Excel spreadsheet into a new Access (.mdb in 2007) table. From the External Data tab, Import box, click Excel. Navigate to the file I need. Click through the windows 'til "Finish". I get an error stating that: "The search key was not found in any record." I've...

I need to copy the calculated values in a column and paste them into a different workbook and/or sheet. Is there a way to copy the values but not the formulae, or similarly avoid the #REF! error? :confused: All I need are the values. How they came about is immaterial. TIA

DOH! They were set as text! Older geologists aren't much help with checking those sorts of things. Thanks! BTW, 'Cdbl' = convert to double? Thanks again, Brian

MS Access 2007 A table of lithology data includes a 'FROM' field and a 'TO' field, which are measured in meters. These fields refer to an depth interval of a piece of a drill hole core sample. The intervals are measured downward from the surface to the bottom of the hole. The 'FROM' value...