ICT access

[nehaloo]

hey ppl! I just wanted to ask hw to write a critria in the query for example :- calculate unit price by cost price! hw to write tht in the critria?!
thnx in advance

 

[Warrior66]

You'll have to tell me which paper and which question (I'd appreciate it if you give me a direct link!). And plz reply asap 'cause I am about to logout. :/

 

[nehaloo]

it is may/june 2007 p2

 

[Warrior66]

ok...plz wait while i find the paper...

 

[nehaloo]

ok.... and srry coz I didnt find the link

 

[Warrior66]

"contains a new field called Cost which is calculated at run-time. This field
will calculate Unit price multiplied by Sales"
Okay so to make this query you have to make a new field named as "COST"------>

 

[nehaloo]

yes I got it! thnxx alot

 

[Warrior66]

no problem and....I hope you understand because otherwise I would have to do the WHOLE paper. if you still don't get it ask again.

 

[nehaloo]

I got it but I tried doin it and still I didn't get the values
btw when I name the field writing [cost] the computer itself writes :Expr:1 cost :/

 

[Warrior66]

oh and just look at this link it might be helpful!
http://fontstuff.com/access/acctut06.htm
Hope you the best!

 

[Warrior66]

okay just a minute.....

 

[nehaloo]

ok

 

[Warrior66]

In that case, if it writes "Expr:1"....then just simply write : Unit*Sales What the computer will now do automatically is that it will write "Expr1:[Unit]*[Sales]" BUT if the brackets don't come up then you'll have to put them in manually. Does it help now?? Tell me after you try it out.

 

[Warrior66]

A file to help you with access:

 

[nehaloo]

still not working

 

[nehaloo]

laaastly I got it DDDDD
thnxx alot

 

[Warrior66]

i think there's something wrong with how you imported the file....try it all over again then see maybe... :/ Look....i seriously don't know where you went wrong and I can't just keep guessing.....could you tell me exactly what's wrong?? :|

 

[Warrior66]

OH! Thank GOD!! I am seriously glad! Good Luck! I'll have to logout now!

 

[nehaloo]

I already got it

 

[nehaloo]

ok...thank u