Thank you so much in advance!
Depends on your exact circumstances.
If you want show 10 per page then you need to
put a list control in the body|||Thank you som much!
SELECT TOP 10 SUM(cd.price) as Sales, ... gave me a list of the most sold CD's + sales figures. How if I want a list including numbers (1 Elton John, 2 Madonna 3, 4, 5, 6, 7,8,9,10etc)
How do I make a list and a sequence of numbers on a report?
Moreover I wonder how to define sales per age-groups? I have a file "age" of customers, need to create groups(<16, 16-20, 21-30 etc) and select sales per group. How do I do this?
|||
curiousss wrote:
Moreover I wonder how to define sales per age-groups? I have a file "age" of customers, need to create groups(<16, 16-20, 21-30 etc) and select sales per group. How do I do this?
You can use a nested IIF within the group criteria to do this.
=IIF(Age < 16, "<16",IIF(Age <21,"16-20),IIF(Age<31,"21-30",">30")))
Note matching the parens can be a pain, but I am sure you will figure it out.
|||Further to this, to create a sequence of numbers just use the RowNumber function.
=CStr(RowNumber(Nothing)) + " " + Fields!Album.Value
