Recent content by Goody974

Thanks Pat for the info. In fact I think the first answer gives me exactly what I'm looking for as it's for creating a calibration certificate which of course shouldn't change. The details stored with the cert will always be the same, but say if the customer moves address then of course we...

Thats great thank you! :)

Hoping someone can help with this... I am such a NooB and have tried searching and experimenting, but clearly I am doing something wrong. At the moment I have a form that gets filled in by the staff with customer name and address details. Each of the address and name boxes are individual...

Thanks DBGuy Its because we are supposed to show what the scale read exactly, Its for calibration certificates. We cant round down, it needs to actually report what the scale read in the denomination it was set in (g, kg, t etc) In your example there, have you got the format to fixed with 4...

Yeah I understand what you are saying I just need to work out a way for it to show the results better for my application. The first column is a load applied to a scale eg, 1000Kg The second column is what the scale read in its own increments, eg 1000.5 The third column is the error, in this...

thank you for your help. I will need to play around with this and see if I can get it to work how I want it to. Appreciate your time.

Wow... I find it strange how its so awkward to achieve. All I want is for a result to be in the same decimal format as the input. 1.5 + 1.0 = 2.5 1 + 2 = 3 1.08 - 1.00 = 0.08 I dont want the staff to have access to change the design values of the database, so I either find a way of access...

ok think I understand. So is it possible to have access read a field and decipher how many decimal places are in there and then format the results field to that automatically?

Thanks, but I thought if I have 2 fields that have numbers with 1 decimal place and the calculated results decimal place is set to auto, why doesnt it show the result in 1 decimal place?

Okay that works, but what do I then do for the results I need to show in whole numbers or 2 decimal places? I dont really want the staff changing these boxes for each different report they need to print.

Thanks theDBGuy, doing this has made the result come out to 2 decimal places when there should only be 1 in the given example... and also sometimes the load and the result will need to be to different decimal places. Somehow I think this is to do with the calculation as the calculated result is...

Hi All I am trying to fix an issue with my database and hoping someone has the knowledge to help with this. In its most simplified format I have 3 fields. One is the load applied, the second is the result noted and the 3rd field is calculated as the result minus the load applied. You should...

Thanks Paul :)

Thats fantastic ArnelGP. Thank you!

Hi All I'm a little bit of a noob when it comes to access but have fumbled along so far. I have created a form along with tables so that I can create a purchase ordering system for myself. I have a table with my suppliers in it, address details etc. On the form, I would like to select the...