Allen,

Allen,

I agree with your comment. Since this was both a database and report issue,
I originally tried to post to both group using the usenet address, but I
screwed up somehow.

Once Jeanette answered my questions, I want to know how to create a total
for invoice with different sub-forms. That is why I posted the question in
the report group.

But I guess I should have waited a day or so before I posted to the other
group.
You point is well taken.

Thanks again.

Dennis

"Allen Browne" wrote:

Dennis, as Jeannette says, you can do what you need with this structure.

In another group where you posted the same question, I suggested another
structure for you.

One of the problems with posting the same question to multiple groups is
that your responses get fragmented, i.e. it limits the way the responses
flow for you.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Dennis" wrote in message
...
Jeanette,

Thanks.

Is the database structure ok? I wasn't sure if I was having problems the
database structure or the report. When I finally wrote out my questions,
I
thought about the sub-report you suggested. But I was not sure if my
conceptualization issue is with my db structure of my vison of the
invoice.

Thanks for you advice.

Dennis.,

.