Raports / Report Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there again

Tnx for Your Replies
I need help again. I, for example, have 4 different products (e.g. 1,2,3,4), but three of them are belong to 1st group and other one to 2nd group
I made one report separate by every product, but now I want in this same rapport in the end (Report Footer) split this four products to two groups (e.g. 1,2,4 to 1group and 3 to 2group) and get total of every group
What function I must use (I think that =IIF() is good but I can get the correct solution)
It will be nice If You can also give some function example

All the best and tnx for replies.
 
What you need to do is add a Group field to your Products table (listing the Group the item beloings in) and include the Group in the source query for your report. Then, in the Report, include a grouping (with footer) for the Group field


----- unKn0wn wrote: ----

Hi there again

Tnx for Your Replies
I need help again. I, for example, have 4 different products (e.g. 1,2,3,4), but three of them are belong to 1st group and other one to 2nd group
I made one report separate by every product, but now I want in this same rapport in the end (Report Footer) split this four products to two groups (e.g. 1,2,4 to 1group and 3 to 2group) and get total of every group
What function I must use (I think that =IIF() is good but I can get the correct solution)
It will be nice If You can also give some function example

All the best and tnx for replies.
 
Try running the report from a query instead of directly
from the table. For the report for group 1 you could
include a Like "1" or "2" or "4" in the criteria field so
only those products show up on that report.
-----Original Message-----
Hi there again,

Tnx for Your Replies.
I need help again. I, for example, have 4 different
Click to expand...
products (e.g. 1,2,3,4), but three of them are belong to
1st group and other one to 2nd group.
I made one report separate by every product, but now I
Click to expand...
want in this same rapport in the end (Report Footer) split
this four products to two groups (e.g. 1,2,4 to 1group and
3 to 2group) and get total of every group.
What function I must use (I think that =IIF() is good but
Click to expand...
I can get the correct solution).
 
Back
Top