- Messages
- 291
- Reaction score
- 1,576
- Points
- 153
q15:
go to report wizard,from the above query select the required fields:name,album title,price fields,avail fields & average price.
go next.....when it asks 'do you want grouping.....' select the field name & create the report...
in design view, insert a group footer & in that place a formula for avg of ave_price field...
add title , header /footer..
hope this helps you.....
btw all the best...when are your exams..??
I'm sorry, but i don't really understand Q.15, can you please explain it a bit more specifically. Thank you so much
i)go to report wizard
ii)select the fields-name, album title, price fields-price1-price2-price3, avail fields-avail1-avail2-avail3 & average price
iii)press next --then it aska do you want any grouping?-----select---name field
iv)then click next & make the report
v)in design view, right click---select 'grouping & sorting--this opens a pane at bottom
vi)in that pane--click on more---click on 'without a footer section'---& change it to 'with footer section'
vii)in this footer enter a text box & enter the formula---=avg([Ave_price])
viii)add name,etc in the report header using a label
hope this helps you.....
when are your exams..??