Search results

I'm having to work to many decimal places in my SQL Server BE & want the user only to have to enter 4 decimal places in the control. Much higher precision is needed for calculations... & the calc can populate the data in the BE which is fine. Restricting what the user sees is easy with the...

Thanks Doc & all. Oh I don't doubt it & I hope I haven't been rude to you @cheekybuddha, especially after so much help you've given me, if so I do apologize. I believe with my current design the precision & scales were required at that sort of magnitude. However I'm starting to realize going...

Thank you sonic, & thank you all for your help. I finally get it & never would have been able to get here without all your help. Thank you so much. To clarify Rule-1 of the Multiplication/ Division Rules. Not the very first rule 1.

Thanks, I need to pick limits to work with & they're going through several multipliers, being converted to percentages & multiplied against each other. So compounding has a massive effect very quickly after the decimal place & I'm trying to find what's going to be the best combination with...

Thanks Dave, I believe we need to use the formula's as per the operation to accurately asses the result's precision & scale as per #17. I need to accurately assess because I have lots of these to do.

Thanks, Doc I didn't post a very good link but the point I was trying to make is that on one of my bad e.g's of LET coercion I cannot see why SQL would convert to SINGLE/ DOUBLE when they are not recognized data-types in SQL Server. Access is not even in the equation atm but the point I was...

Thanks all, spent a lot of time trying to understand this topic & this is not my first post on this kind of thing... Do Calculations Inside Decimal Data-Type Suffer Memory Truncation? @RonPaii apologies - I've made things more complicated where I'm struggling to grasp a basic same-type Decimal...

Thanks Colin & Ron. Windows Calc gives me the same as the website VBA gives me same as Excel; though I won't be using Access a great deal as most of the work will be done in SQL Server. Access will just be displaying data (to less decimal places & with less accuracy) but that's fine. The BE is...

Thanks Mark, I'm a little familiar with BR, but I thought the whole point of using decimal is that it's precision is guaranteed. I thought SQL Server would use BR but this suggests it does not. Obv's you'll know a lot more than me. There must be a way to disregard client computers... because by...

Simple math: 1/1.95: In Excel, formatting cell to 16 dp & counting on screen the dp's I get 0.5128205128205130 Online Calculator I get 0.5128205128205128 In Sql Server using SELECT CAST(ROUND(1/1.95,16) AS DECIMAL (28,16)) AS WTF I get 0.5128200000000000 I'm lost for words :unsure:.

Thanks MajP, Chat was wrong & you were correct as usual MajP, Format forced it thank you very much. Hope you're well mate. (y) 0.0000000000000000 Thanks Doc it was a Datasheet.

I have a SQL Server BE with table design as pic'd: Access can display a Decimal Type to 28 Precision (overall significant figures), to 16 Decimal Places BUT the spec of DP's have a maximum fixed value of 15 it seems ; so playing it safe I have dimensioned the design as 15 dp's; resulting in...

Sorry, please delete. Despite trying many times prior & this exact fix which did not work previously. I removed the data source, saved & reloaded. Then used the PT Query & it works. Don't know why it did not work previously.

I've converted the BE to SQL Server & a previous listbox is causing the above error. I've removed all event associations with the form & commented out the code in VBA but I still get the prompt. It is strange that it is only this listbox (where there are many other controls on the form) which is...

That's good you saw a change & I'd think this is indicating moreso where the issue is. Maybe try Ctrl-H & manually going through each var individually. That's helped me before with Option Explicit not checking every single var. The problem will be in the FE. As you can see I've had it before &...

Thanks MadPiet, yeah I've read that too, & probably the reason why I've been on it a few days. On a positive spin I'm trying to obfuscate code as much as possible so that's a positive. But it is quite awkward I must admit. I keep looking back & forth.

Thanks Tom, I did check the execution plan's, there were quite a few steps compared to basic tut's I've done, I've spent a good few days researching & nearly finished rewriting with indexed views. I'll test & post results but i only have a few rows. EDIT - I am forgetting, it is necessary to...

I don't think you're getting it @Geirr: EDIT - apologies @Geirr, I see what you're saying; maybe something like below & edit all occurences via Ctrl-H... It is agg; I get what you're saying...

Thanks Tom, I was casting a decimal; probs made a crap job of obfuscating my real code; sorry. The biggest questions I have atm is - 1 - Is there a benefit to indexing a view on an column which is already an index in the table? 2 - Is it worth all the aggravation, trying to separate & nest...

I could be wrong in saying that you're experiencing a lucky coincidence here as you're likely testing in same office company with equipment purchased on roughly same date. If you are not linking to many libraries then with good luck you won't have many errors trying to reference non-mapped...