ICT : Post your doubts here !

[reina81]

look we're supposed to make a normal query first right? so in that query is the >3 supposed to go under the product field or what?

 

[PhyZac]

yes that's it

i think i am stuck there too :/

 

[PhyZac]

look we're supposed to make a normal query first right? so in that query is the >3 supposed to go under the product field or what?

yea, the easiest way is to do normal first..
>3 is supposed to be under product....
but as i checked ur ryt its text so their myt some wrong with wat i did.. :/
seriosly i hope no summary to come

 

[PhyZac]

got my mistake i think so,
first we will do a summary of product Stock Country
then we will count the country product those more than 3 will be then filtered!

 

[reina81]

got my mistake i think so,
first we will do a summary of product Stock Country
then we will count the country product those more than 3 will be then filtered!

i don't get your way, but it works if you just make a normal query with only the country product and stock fields. then in the query there is this "Totals" option (representated by a sigma) you choose this and then in the query you select the sum and count stuff for the respective fields from the drop down box.

 

[Aliya]

Guys please answer this..When using hotmail, there is a button that says show cc and bcc..what if i only want cc? how do i get rid of the bcc?

Thanks in advance!

just opt them off... there's a button above the bars.. near the bar for typing mails... click there....

 

[Alaa Hassan]

just opt them off... there's a button above the bars.. near the bar for typing mails... click there....

I had my exam today..and i left the bcc blank..thats fine right? will i lose marks?

 

[Yours Truly]

I had my exam today..and i left the bcc blank..thats fine right? will i lose marks?

Absolutely not

 

[Aliya]

In MJ 08 (paper 2) step 43 they asked us to show the records where the 'Notes' field is not blank. How do I do this?

I had my exam today..and i left the bcc blank..thats fine right? will i lose marks?

it doesnt worth many marks
i think its okayy
i also had my exam today
and i have tomorow also

 

[Alaa Hassan]

it doesnt worth many marks
i think its okayy
i also had my exam today
and i have tomorow also

In other words..i will lose marks right?

 

[Aliya]

In other words..i will lose marks right?

uhh
i m not sure
but i think u wont lose many marks tho

 

[Alaa Hassan]

uhh
i m not sure
but i think u wont lose many marks tho

So y did u respond from the first place..thanks anyway but i want a proper answer..

 

[Aliya]

So y did u respond from the first place..thanks anyway but i want a proper answer..

o wel
i just told
what i thought

 

[Yousif Mukkhtar]

I just finished my paper 2. It was good. You just have to concentrate very well on the access questions.

 

[reina81]

in criteria write: <>""

do i always use this if the ask for a field to be not blank? and also, when using wildcards is it necessary to use inverted commas, for eg, like "*tea*" or does access automatically add them?

 

[NIM]

yea, the easiest way is to do normal first..
>3 is supposed to be under product....
but as i checked ur ryt its text so their myt some wrong with wat i did.. :/
seriosly i hope no summary to come

No summary and labels r there in Paper....

 

[Fuji Fujiwara]

Dude could you please send me the photos to show how to change the size and took colours out from a picture? Please send me the photo step by step since I need some direct images to help me to remember!
Danke schön!

 

[NIM]

In queries can someone explain when do we use 'like' * or 'Like' #

when it says "contain" thats mean v r supposed to use 'like'*
and if says "only" than just simply write the criteria...

 

[NIM]

help in makin graphs in excel??

graph is not coming...

 

[PhyZac]

Dude could you please send me the photos to show how to change the size and took colours out from a picture? Please send me the photo step by step since I need some direct images to help me to remember!
Danke schön!

how to change the size can be done in many places, powerpoint word paint MS picture manager ? which one u want ?