Record Values made by Product of 2 other fields

[namliam]

I learnt it in skool aswell
1NF, 2NF and then 3NF

Thanks for that!

See i allways said school is good for nothing....


Regards

 

[Mile-O]

See i allways said school is good for nothing..

It's "skool!"

 

[Only1Abhi]

Pat said base the form on a query and not the actual table.

Do I need to add any other fields in the query?
I mean calculated fields?

And if yes, what kind of forumlae (or criteria) goes with it?

It's skool!

S-cool is soo cool!

http://www.s-cool.co.uk/

 

[Mile-O]

You don't need the calculation in the query as you are performing it on your form.

 

[Only1Abhi]

but doesn't that just display the calculated value on the form?

I need to store it aswell!

Thanks!

 

[Mile-O]

THOU SHALT NOT STORE CALCULATED VALUES

 

[Only1Abhi]

Bloody Hell people... What is it?
One of the 10 Access commandments? (lol)


If I shouldn't store calculated values...
Then what's the alternative?

 

[Mile-O]

Are you taking the piss?

 

[Only1Abhi]

lol Mile...


No I'm not...

But what's the alternative?

 

[Mile-O]

Please...enlighten us as to why you need to store this calculation in a table.

 

[Only1Abhi]

I need to print out the records.

If I don't have the value calulated and STORED, then I'll have to work out each and every record one at a time and type it.


That's why!

 

[Mile-O]

lol, you can also do the calculation in a report.

Absolutely NO need to store it in a table.

 

[Only1Abhi]

People Killing People Dying
Children Hurting and even crying
Can you practice what u breach?
When U start learning Peach?

Father Father Mile-O-Phile please help us...
We need some guidance from above...
Can you please please tell me...
Where is the love?

(I mean how can I do calculation on report)?


Thanks!

 

[Mile-O]

The EXACT same way you would do it on a form. Put a textbox on and put the expression in its ControlSource.

 

[Only1Abhi]

thanks!

THOU SHALL NOT STORE CALCULATED VALUES

Are You taking the piss?

Lmfao...

Too funny!

Mile... Thanks buddy!

 

[Only1Abhi]

hey Mile-O-Phile-Out,


I have a problem bro. I need the Total field to change INSTANTLY. Because I may want to change the Amount & Qty fields to see what changes it brings on the Total.


So that's a good reason to store the calculated value...

Now you're gonna say:

THOU SHALL NOT STORE CALCULATED VALUES

Then what's the alternative?
And now I have a good reason to NOT use report calculations.

Please help.
Many thanks!

Kind Regards,
Abhi

 

[mission2java_78]

Here's a better solution...

read a book.

 

[Edski]

Actually the cursor does not necessarily have to leave the changed field to show you the result. You can use the OnChange Event for either the 'Qty' or the 'Amount' fields and show a message box with Nz(Amount,0) * Qty.Text (putting an error trap in case Qty is Null). Whenever you change one digit of Qty, a message box will pop-up with the instantaneous result, but Access won't store the result in the Total field until you leave the field. Not sure if that's what Only1Abhi had in mind though.

This was a very amusing thread by the way. Thoroughly enjoyable.

 

[namliam]

We seem to have come back to my solution. I am supprised that no one understood it well enough to explain it to you.

Pat,

I understand/understood it allright however AliBaba (aka Only1Abhi) was hell bend on storing the damn value and it took us 3 pages of 'discussion' to get him to not store it (atleast i think/hope he is not storing it any more) From his last post:

So that's a good reason to store the calculated value...

*SIGH*This thread is no longer just a way of getting a problem out of the way, but it has become *amusing* (as edski said). Trying to keep Abhi 'on the right path' away from 'the dark side'

Regards

 

[Mile-O]

Trying to keep Abhi 'on the right path' away from 'the dark side'

It's too late; he's already listening to the music of Craig David.