total from a different table

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:
 
K

KARL DEWEY

Place the total from the table Provisie in another report and use as a
subreport.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report showing totals from two tables 5
combing fields from different tables 3
After Unmatched Query Runs, Getting the Difference from Totals 3
Query Total from two different tables 5
Totals Query from Multiple Tables 1
total days worked for individuals from different rows on a table 0

Top