Creating a sales invoice form

[chris100]

Hi everyone,

Long Long time since i've used Access. 2007 version has changed a lot since ten years ago!
I am desparately in need of help to complete my little brothers coursework.
I need to create a form where very simple orders can be placed for customers. However, i'm not sure how to combine the orders table with the customer table to create one form for entering orders.

Sorry i'm a little vague but i'm at a loose end.

Thanks all,

Chris

 

[RuralGuy]

Have you looked at any of the templates that ship with Access?

 

[Pat Hartman]

Welcome aboard Chris but have you considered letting your "little brother" do his own course work? What does he learn if you do the work for him?

 

[chris100]

Thanks Pat. I have but hey, we all need a little help sometimes and it's not like i'm doing the whole thing. He can learn through example - just like others learn on this forum in the same way - hell i taught myself vb from using excel forums just like this one and asking a bucket load of questions and examples!

With regard to the templates i've looked at the old '03 ones as they include an ordering system. With a little experimentation we're sorted out the forms issue.

Sure i'll be back with some more questions though!
Regards

 

[RuralGuy]

At least we got you moving along again but Pat has a good point.

 

[Lyn Davies]

Hi Chris
My query is with a sales invoice - the one I am using is in the Time and Billing templates. It has everything you need (probably more) and is easy to change around, but what it does not have a VAT section - as a new user to Access, I'm having problems trying to get the 'total' to include my vat!

 

[Rabbie]

IN your report Have a field thathat shows the Net Total and another that shows the Vat then your GrossTotal should be set to [Net Total} + [Vat]