Doug Steele
dbdoug at gmail.com
Fri Feb 3 09:31:17 CST 2012
Because of the number of times that reports and other queries reference the invoice totals but not the detail, I always put an invoice total field in the header record. It's a bit more effort to make sure the total field is always correct, but saves a lot of fussing later. This is particularly helpful when an invoice might have several different types of detail records (labour, materials, services, taxes) etc. Doug On Fri, Feb 3, 2012 at 6:18 AM, Susan Harkins <ssharkins at gmail.com> wrote: > What have you tried so far? > > I remember writing about this years ago, but I don't remember the actual > solution. Seems like it's just a matter of referencing the subreport > control correctly. > > Susan H. > > > I need to generate an invoice with expense items. I would like to do a >> subreport to insert the expense items in the report, then pull the sum of >> the expenses up into the main report. Does anyone do this and how do you >> handle it? >> >> -- >> John W. Colby >> Colby Consulting >> >> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd> > Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> >