- Messages
- 1,162
- Reaction score
- 6,306
- Points
- 523
All d best ppl..pray n sleep well...tahajjud 2mrw n plz pray 4 all of us...
may v get d best and d Best. aameen
may v get d best and d Best. aameen
We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
Click here to Donate Now (View Announcement)
i havent solved this but looking at qp & ms i guess they are just asking to show evidence for filtering gender for females and age for 12 to 31w12. q27. hw do u gt 2 noe d most common rating?
Student of the year
jazakumullah....if you want to find yet then first make a new column to calculate the no of stars in each cell, in the next column enter =len(range)
then to find most common use mode function =mode(range) this range is the column....
.....
I need help in november 2008 Q21-23....Pls help quick!!!!!jazakumullah
21. query= u'l noe dis by nowI need help in november 2008 Q21-23....Pls help quick!!!!!
In q21...My criteria isnt working i dont know why..........21. query= u'l noe dis by now
22. comparing no. of employees, avg pay 4 each qualification. 4 no. of emp, u mk a query in which u average d pay n count (count records in d query).
extport dis into exel n mk a line graph. label it all over
hp it helped.
May Allah help us all.aameen
I'll do that paper again in a bit and see where I went wrong. Did winter 2012 for my mock exam 2 weeks ago and messed up big time :/u sure u grouped by branch?
wn mkg d report, (grouping), go 2 grouping options and ensure dat "Normal" is selected 4 Branch.
If it specifies in the header than you add a label in the header on the right hand side because the title is usually on the leftI'm sorry this may sound like a ridiculous question but how do you actually add the candidate details in a report? So far I've just been adding a text box and doing it at the top of the page but how exactly should I do it? ._.
Ohhh okaay. I can do that even if it isn't specified yeah? orz I'm a newbie when it comes to practicals, please excuse my idiocyIf it specifies in the header than you add a label in the header on the right hand side because the title is usually on the left
ANOTHER QUESTION D:
When I try to make grouped reports, the data get's repeated. Like in winter 2012 paper, step 14-15. The branch name gets repeated, like Berlin, Berlin, Berlin, next one etc etc :/
ooohh ohkyy nd btw u need not show berlin nd stuff read d ques once again carefully it says ONLY SPAIN ND GERMANYactually it's just step15 but no ._. atm i'm trying to figure out how to not make it repeat.
no they want us to show the BRANCHNAME which has all those berlin, granada etc. branchname and total number of staffooohh ohkyy nd btw u need not show berlin nd stuff read d ques once again carefully it says ONLY SPAIN ND GERMANY
ummm m sorry...ask sm1 else plz...if i get 2 knw will let u iAno they want us to show the BRANCHNAME which has all those berlin, granada etc. branchname and total number of staff
sure haha no problem thanks anyway.ummm m sorry...ask sm1 else plz...if i get 2 knw will let u iA
15. it says: "average price of an album 4 each artist". so, logically wt would u do? average the average.. =avg([Ave_Price])I'll do that paper again in a bit and see where I went wrong. Did winter 2012 for my mock exam 2 weeks ago and messed up big time :/
Another question (so sorryyy >.<). In summer 2011 step 15, report creating part, we have to include the total average price of albums for each artist. So for this I have to go for summary options >> sum by the avg_price right? ._. When I do that the avg_price field isn't there and I don't get a sum value at all, just a label 'Sum'. I hope you get what I mean
Edit: Do I have to make a separate text box and assign the controls? like sum(Avg_Price) etc?
For almost 10 years, the site XtremePapers has been trying very hard to serve its users.
However, we are now struggling to cover its operational costs due to unforeseen circumstances. If we helped you in any way, kindly contribute and be the part of this effort. No act of kindness, no matter how small, is ever wasted.
Click here to Donate Now