M
mmfbusy
Hi.
I'm fairly new to access. I've design a database that we'll use for
automating our invoice process. We have numerous customers and each has it's
own prices for our products. I created tables with relationships to hold this
information. I broke my database into a frontend with forms, queries, etc and
a backend with the tables.
That's all working fine.
I've run into trouble
I have a products table, a price table.
I created an order and an orderdetail table.
I used the Northwind and the Access2000 Books databases as guides.
In addition, we have special orders. I have another table for
specialorderdetails. It works the same as order details. I don't want those
items on my products table. They're just one time things.
So I created a form with 2 subforms - 1 is for products and 1 is for specials.
They both run sums. I then can display a field for each on the form and
display the sums. I can calculate tax on the subtotal.
But I don't always have a selection on both tables - my sum won't display if
I don't put something in the row - then it shows up on my printed copy. I
tried putting in a default value of 0 but that doesn't seem to matter.
Also my subtotal won't add without a value in both sums. Am I missisng
something obvious?
Is this enough information for someone to help me? I've spent hours trying
different things and I just can't get it.
HELP!
Thanks!!!
I'm fairly new to access. I've design a database that we'll use for
automating our invoice process. We have numerous customers and each has it's
own prices for our products. I created tables with relationships to hold this
information. I broke my database into a frontend with forms, queries, etc and
a backend with the tables.
That's all working fine.
I've run into trouble
I have a products table, a price table.
I created an order and an orderdetail table.
I used the Northwind and the Access2000 Books databases as guides.
In addition, we have special orders. I have another table for
specialorderdetails. It works the same as order details. I don't want those
items on my products table. They're just one time things.
So I created a form with 2 subforms - 1 is for products and 1 is for specials.
They both run sums. I then can display a field for each on the form and
display the sums. I can calculate tax on the subtotal.
But I don't always have a selection on both tables - my sum won't display if
I don't put something in the row - then it shows up on my printed copy. I
tried putting in a default value of 0 but that doesn't seem to matter.
Also my subtotal won't add without a value in both sums. Am I missisng
something obvious?
Is this enough information for someone to help me? I've spent hours trying
different things and I just can't get it.
HELP!
Thanks!!!