D
Dmac
Hi group,
I am a newbie who could use some help.
I am having a difficult time trying to display a totals at the bottom of my
invoice. Of course it isn't just a regular invoice.
I have three tables that I am getting my information from.
tblcustomer, tbljobs, tbldocksections.
Relationships:
tblcustomer has a one to many relationship with tbljobs.
tbljobs has a one to many relationship with tbldocksections.
The report uses a query that pulls the data from tblcustomer, tbljobs,
tbldocksections based on JobID (User input). The user types in the
corresponding JobID number and the query returns the customer info, job info
and all the deck sections.
Since there can be multiple dock sections per job, I set the form so the
customer information is in the form header. the job information is in the
form footer and the dock sections information is in the Detail section of
the report. It looks and works neat. Granted, it is probably not a very
good design, and I would definitely be interested in any constructive
criticism.
The problem I have not be able to conquer is adding up all my prices. The
problem lies with the docksetions portion in the detail section of the
report. I can add up all the rest of the fields, however, if there are more
than one docksection, it will only add in the last one printed.
Is there anyway to correct this problem or should I scap the design and
start over?
Sure could use some help. Hope I explained this well enough. If not, I
will try to clarify.
Thanks group.
I am a newbie who could use some help.
I am having a difficult time trying to display a totals at the bottom of my
invoice. Of course it isn't just a regular invoice.
I have three tables that I am getting my information from.
tblcustomer, tbljobs, tbldocksections.
Relationships:
tblcustomer has a one to many relationship with tbljobs.
tbljobs has a one to many relationship with tbldocksections.
The report uses a query that pulls the data from tblcustomer, tbljobs,
tbldocksections based on JobID (User input). The user types in the
corresponding JobID number and the query returns the customer info, job info
and all the deck sections.
Since there can be multiple dock sections per job, I set the form so the
customer information is in the form header. the job information is in the
form footer and the dock sections information is in the Detail section of
the report. It looks and works neat. Granted, it is probably not a very
good design, and I would definitely be interested in any constructive
criticism.
The problem I have not be able to conquer is adding up all my prices. The
problem lies with the docksetions portion in the detail section of the
report. I can add up all the rest of the fields, however, if there are more
than one docksection, it will only add in the last one printed.
Is there anyway to correct this problem or should I scap the design and
start over?
Sure could use some help. Hope I explained this well enough. If not, I
will try to clarify.
Thanks group.