Search results

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'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...

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...

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

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...