Search results

Beautiful link @RonPaii, thank you, I didn't come across that MSN article which was exactly what I needed. It used to be a popular phrase In English/ Irish communities. I've rarely heard it from my age group, but working on site with the older Irish generation it was commonly used, but less so...

Thanks Doc, I am aware of the enigma with multiplication & division, but thank you for prompting had I not been aware. Don't worry about the possibility of different data-types being used as terms within the expression; I have this covered. I also have it covered where the decimal places...

Congrats @The_Doc_Man, well deserved!

Thanks Doc, Access will be fine with 17 decimal points to display enough accuracy, it is the calculations done in the back-end where i need the accuracy. Are you saying that I need to explicitly round all intermediate calculations regardless of their specified decimal point spec? An...

Thanks Ron, most intermediate calc's are Decimal(38,26) so it seems type-inheritance applies. I'll round intermediate calc's where <> (38,26). Overflow Errors - thanks, there's always going to be a limit so I'm not too worried about this as I'm designing around reasonable spec's for the...

I'm no mathematician either, but I need to be accurate to 26 decimal places to minimise nested compounding; playing it safe to minimize problems. I do need big numbers mind as the calculations need to be as accurate as possible with linear regression (probably the wrong term). It's quite a pig...

Will the specification of the Decimal data-type apply to all calculations wrapped inside the Decimal data-type & each calculation inherit the accuracy specified by the parent Decimal type (26 decimal points in e.g.). I'm hoping it does because I have complex calculations which I do not want to...

Thanks George, much appreciated, I'll go composite index route.

In Access I used a composite index of 2 fields, but unsure best option in MSSQL for performance to avoid a duplicate record of the combination of the 2 fields? In the child table (relevant to topic) I have a foreign-key & a normal field. I think I have 2 options? Composite Index like in...

You have a great understanding for a first post. So obviously the below Entity Relationship Diagram (ERD) is not going to be fully correct (no doubt massively wrong knowing me) but a gist. Pretty much everyone on the forum is more capable than myself, but in trying to lend a helping hand; I...

@GPGeorge, thank you so much for taking time out of your day for this articulate explanation (the best I've come across after a week or so full-time research where full detailed articles & all MSN research... don't compare to this fine explanation). After much research I could not ascertain...

I would think the OP will require the recordset of the form to be editable, but enjoy the benefit of fast calculated fields in the view/ stored procedure/ function used inside a field of the query. 1 - Testing on a view in MSSQL; which is editable. The view then needs to be reloaded & the...

No that's helpful info, thanks for sharing.

Thanks Dave, ok I'm greatly outvoted here & I take onboard a unanimous vote from the experts with much greater experience than me. Thank you all for your input, greatly appreciated.

Thanks all for your honesty. Thinking of network performance with Azure, doing a very rough calculation (no doubt wrong :p) I have around 108,000 records * 6 average sub-records = 648,000 sub-records in this one area alone. relating to one container. I won't go into detail spilling out my...

Life is short, do what you want I think. But credit to you, it mustn't be that bad for 15 years of use & so happy that don't want to greatly deviate.

Int > TintyInt/ SmallInt/ BigInt... Seems no point in wasting space with some of these. I don't need to waste space generically assigning these data types with the PK's/ FK's to int. Don't get me wrong some will be, but I'm going through them now determining what sizes I reasonably need for...

EDIT - On closing & reopening MSSQL the changes have taken effect fully. I can handle the 4 FK constraints manually; that's no big deal but would appreciate if someone can help in doing this for PK's? After importing to MSSQL I want to convert certain FK's/ PK's data-types. So need to drop all...

Persevere, you're close. I struggled with this also. You're wrong on below, but logical so don't beat yourself. Pretty sure I did exactly that when experimenting also. qdf.Parameters(sPar1).Value = sFreq It's possible. If your intent is to set the parameter in VBA & run the query (you will not...

Oh dear, this is really not good for me 😭.