Search results

best part is I have 2 solutions, and learned some things...

Frustration can look like resentment when people point out things other than your problem at hand... It felt like..... My car wouldn't start and someone insisted on informing me that I had mismatched tires....

OK, I took that and tweaked it, tmpCorrention had to have an e added, and I changed my database to have integers since you used Int(). I also realized after looking at my spreadsheet commands that I really did not need V4, I did not use it... it uses v2-v1 and v3-v1 for the multipliers...

the error, yes, probably should look at that, I did find one character incorrect in the entries I copied from the array to the 3-column table not worried about interpolating an exact number, it still works out correctly, and keeps code simple...

I am using 1-11 degrees in my example, as that is all the database has populated at this time... even with cutting and pasting hundreds at a time, it is still 7000 cells, I will do the other 63,000 or so when someone provides a working piece of code...

NO, it is shorthand for look up 100 proof at 10 degrees 100p@10deg --> 100 in rawProof 'at' 10 in rawTemp you will get back key 119.40 degrees (happens to be key 1954 ) man, that table sure works nice! Also, you cannot look up a decimal, only whole values are in the raw data, you have to do...

Well then, now that I have made the db table to their liking, I should expect working code? or will they sharpshoot more... Maybe I just look at this as how computer architecture would access memory, a 100 bit wide bus is certainly faster than a 1-bit wide one, right??? total number of...

I spent 10 minutes doing the first 11 degrees(2266 lines) in excel, I imported them to access and it chopped them up because some fields were empty... I spent another 10 minutes reformatting the spreadsheet and re-importing, attached is a snapshot. it will take an hour and there is a lot of...

IMHO the field names, even though they are numbers, are no more a piece of data than the field name of "FirstName", "LastName", "Address 1" "Address2", City", "State", "ZipCode"... it is a 2-dimensional data field, an array.... Think of a fuel map database for fuel injection, do they unmap...

OK, I used trim to get rid of the leading space, and still got an error... 'type mismatch' error in first .png , which is something I can work with.. The 2nd .png shows the double quotes, so I deleted the Chr(34) from in front and behind the Temp and Temp1 statements. And BINGO... it...

I may have found it, here are a couple screenshots with mouseover notes... The first is where it errors.. In the 2nd, it looks like there is a leading space in my [Actual Temp] or Temp/Temp1 fields... I will work on getting rid of that... I am not sure if there is really an extra set of...

I have changed the 20 of so fields that were 'short text' to double-general like the rest, it is likely they went that way because the first 70 entries are blank... What I *think* I need to solve the issue is the correct syntax to take a field value, in my case [Actual Temp], make it into one...

but 20,600 entries is not simple... 31(key)...1(proof)...31degrees)...1.7 (corrrected proof) ... ... 94(key)...1(proof)...94(degrees)...0.1(corrected proof) 95(key)...2(proof)...31(degrees)...2.7(corrected proof) ... ... 20,600(key) 206(proof) 100(degrees)...199.6(corrected proof) IMHO, that...

I don't have a lot of debug skill in access, but your pointers should help me poke around... thank you...

Federally mandated. absolutely no room to wiggle I cannot post URL yet.. removed url tags and added hypens: www-ttb-gov-/foia/gauging_manual_toc.shtml#27:1.0.1.1.25.5 1 - Making it rows that hold 2 values will be 100x206, or 20,600 entries.. not 206, that is unrealistic. I would have to...

I have read as many of the posts on this and similar subjects and still having an issue. Heck, maybe I shouldn't even be using DLookup. After all, I just want to give the 'x and y' of an array and return the result! background - I have a table in my database that is a temperature correction...

Googling for 8 hours and still not quite there with my problem. I came to the site that helped me the most so far in hopes of getting help on a specific issue with the database for keeping daily records for my Craft Distillery near Clearwater, FL... -mike