total from a different table

  • Thread starter Thread starter Ronlegebeke
  • Start date Start date
R

Ronlegebeke

i have a report based on a query names invoice with the following data:

Cname rnumber article price
Jan 000001 10101 6,75
Jan 000001 10102 8,00
Jan 000001 10105 5,00
Jan 000003 10103 7,00
Jan 000003 10106 3,00
Jan 000003 10104 9,00

than I have a table named Provisie with the following fields:

rnumber provnorm provfabr
000001 11,75 8,00
000003 10,00 9,00

Now I want to create a report with the detailrecords from the query:
Jan 000001 10101 6,75
Jan 000001 10102 8,00
Jan 000001 10105 5,00
Jan 000003 10103 7,00
Jan 000003 10106 3,00
Jan 000003 10104 9,00

And a total from the table Provisie:
 
Back
Top