Novice
Windows 7 64bit 
Access 2007
Hi. I hope someone can help me. I have a customer database that I use and want to create quotes from; however, the form footer sum function is not working. I need to have it multiple the size by price by qty. Both the price and qty field are text boxes but the size field is a lookup field. I understand that the sum function is not able to use calculated fields. Is there a way around this to make my sum work? I have attached a dummy database to assist in understanding my question.
Thank you
Access Developer
Windows XP Access 2003
Can you attach a copy in A2003 mdb format.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Novice
Windows 7 64bit Access 2007
Here is a 2003 version. Thank you
Access Developer
Windows XP Access 2003
I am unable to open it without a password.
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
Moderator
Windows XP Access 2003
In your relationship diagram what do tblStates_1,tblStates_2,tblStates_3,tblStates_4 represent?
Why are they there? same for tblCustomer_1 tblQuote_1
I have removed them and tried to simplify the picture.
I'm not sure I understand How Quotes for Products are related to Customers.
Could you describe the tables and relationships in overview?
Novice
Windows 7 64bit Access 2007
I'm so sorry. Try this one.
Novice
Windows 7 64bit Access 2007
There is a customer table which can have multiple quotes. Within each quote there is a subform listing the products for that quote.
Moderator
Windows XP Access 2003
Your demo2003 is an accdb file?
What does the link between Quote and Product mean?
Novice
Windows 7 64bit Access 2007
That's weird that it saved like that. try this
Moderator
Windows XP Access 2003
That's an mdb.
Do you Quote just 1 product at a time? Do you really have Orders and LineItems?
see the discussion on this link
http://stackoverflow.com/questions/5...-order-invoice
Novice
Windows 7 64bit Access 2007
Thank you. Each quote can have multiple products. Each product on the quote is consided a line item then we have orders based from those quotes we need to capture.
Moderator
Windows XP Access 2003
I suggest you read the thread at stack overflow from earlier post and work with that data model and comments. It seems to mimic
your situation. It also seems thorough with respect to the Quote->Order->Invoice.
Good luck with whatever approach you take.
Report Footer "Missing Operator" message
Total at end of details section not report footer
Posting Permissions
Reply With Quote