Recent content by starman0724

Skip, I tried to initiate a query, but it tells me there are no tables. Here's the scoop. We're performing a countif function that's based upon today's date...ie when the macro is run. In order for that value to 'save' a fixed value (ie not a calculated field), I copy to columns non contiquous...

Skip, First of all...thank you for your speedy reply... The data is on the "Summary" sheet, in cells AE1, AF1 and AE2. AE1 & AF1 are data, and AE2 is the date. These don't fall into a table format, do they? I suppose I could rearrange my data if it will enable a smoother project. Please feel...

I have data in many worbooks which needs to be compiled for charting. The many worbooks have filenames with a common convention and date stamp. Example: 123456 - Chicago 2004-10-25.xls. There are only 3 cells on one worksheet of each file which contain the needed data. I'd either like to make...

Thankyou for the tip on coloring the cells given certain criteria. My problem is something like this: I've got data from an external source which provides a condition "priority". This priority needs to be color coded (yes, the color of a traffic light...1=green, 2=yellow & 3=red)...

I realize this is probably an overly easy question, but I'm frustrated with manuals, and the help screens. What I'm interested in is counting the cell background fill color red, yellow or green), (I've got the function to do that) IF a certain cell meets a particular criteria (such as after a...

Mike...I don't know about the issue with the missing join....those seem to be beyond me as well. However, the first Make table query I run gives me the correct number of records, and then I run the corrected mid function on that table...it works good that way. Thanks! Ken PS - I've still got...

I thought the problem was licked. I've got two tables from an external source via ODBC drivers, right? Table 1: Area has "AkeaKey" and "AreaID" -- AreaKey is a Primary Key Table 2: Equipment has "AreaKey" and "EquipmentID" -- AreaKey is a Primary Key...

Mike, how do you read this language in your brain. After several minutes, this is what I came up with on a new SQL query: SELECT Cstr(AreaID)+Cstr(EquipmentID) AS MP2 FROM Area, Equipment SELECT Mid(MP2, 1, 4)+"-"+Mid(MP2, 5, 4)+"-"+Mid(MP2, 9, 4) as MP2n FROM qMerge; I...

I was reading, hoping to learn something myself. I have an Access database which imported ODBC data into 2 tables. One table is "Area" with and AreaID (2 digits) and the other table is "Equipment" with EquipmentID (10 digits). I need to "merge"? the data into one...