Search results

people, don't worry i had apparently created the textbox in the page footer, not the report footer! DoH!:rolleyes: Thanks anyway... And 1 more quick thing please. In the tbl,qry and report... I have a date of when the Transaction was stored, i.e. a Date field. Is it possible to view only a...

Hi People. Just a quick question please. Tables: tblTransaction Query: qryTransaction Report: rptTransaction I select only a certain records from the query into the report. there is a field in the report (and the tbl and qry) called Finance. This has a number data type. At the report's...

thanks, it worked! ;)

Hi. I have a table with lots of fields, but 2 in particular. In Table Design View, I have set these 2 fields to Long Integer field size, General Number format, 2 decimal places, default value 0, NOT indexed, NOT required. But when I type a value in the table in these 2 fields (or in the form I...

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: Then what's the...

thanks! Lmfao... Too funny! Mile... Thanks buddy!

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...

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!

lol Mile... No I'm not... But what's the alternative?

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?

thanks... Worked... :p (just love this smiley) :p :p :p :p

but doesn't that just display the calculated value on the form? I need to store it aswell! Thanks!

thanks IMO, but where do I enter it? And will the value be stored or just displayedon the form? I need the value to be stored!

thanks sprax but where do I enter that?

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? S-cool is soo cool! :p http://www.s-cool.co.uk/

ok yeh! I understand that now! I learnt it in skool aswell 1NF, 2NF and then 3NF Thanks for that! But I don't understand that quote by Pat on my last post. I mean I've even looked in F1 help but it's kinda confusing for me. Can you please explain it to me? Kind Regards, Abhi

lol... then again people... I was thinking... Is it possible for the "Dates" field (updated name of the field "Date") to have TODAY's date automatically stored everytime? When I make a transaction, it will be automated to TODAY's date. But when I make a transaction tommorow, I want...

I don't understand what the problem is with storing calculated values.. But I'll take your word for it! And I didn't understand Pat completly... Can anyone please explain this part clearly please (step-by-step): Many thanks! Regards, Abhi P.S. THOU SHALL STORE THOU CACULATED VALUES IF...

yeh thanks! It did work actually! The regional settings on CONTROL PANEL had language set to English (US) and not English (UK) That solved the problem. Many thanks people! :)

Someone else on another forum suggested that! My default language is: English (UK) My time is: GMT (for London) The information above is local and CORRECT! But I still have the problem! What Can I do?