Qualification > Miscellaneous

URGENT ICT HELP!! exam on 19th!!

<< < (3/4) > >>

ksitna:
thing is i keep getting 1s for the count
i dont get it  :-\

JD46:
I  GOT IT!!! ;D :D :)

1)i used to get 1's before but you gotta, make a noraml query with  wizard,then  you gotta click on the total button(looks like a weird kinda E)a row will appear there u gotta leave country as 'group by' and change the other 2 to sum and count(what eva u is required),checked with the MS ,its right!

Thanks nobody and the others for being so supportive and helpful,you guys kept my spirits up! :D

~HyDrOgEn~:
I did not post anything.
Please forgive me.

Saladin:
Please do not ask for any information regarding the ICT practical, or else you will get permanently banned.

JD46:
49)Using a lookup function replace the initials for each member of Staff with their Full
name using the file N7STAFF.CSV  -ON07(october/November)

Staff   Sum Of Sales   Count Of N7STOCK
CP   414                          16
CS   26                           7
IS   197                          25
KP   205                          10
PO   115                           7
RT   236                          12

How do i do this!? ,vlookup isn't working somehow!!

Navigation

[0] Message Index

[#] Next page

[*] Previous page