Microsoft Access ® 2003 Sales Invoice: 2 Query

[DPx111]

how do you make forms ? i mean what form do i need to make for this invoice

[RaviKings]

ure video didn' t help at all.

[anasaau]

Thx man ...

Well explained :)

[earnfast98]

Great Videos! I have a question though. In making an invoice in an Invoice Form, how do I limit a Products Listbox to show only items covered only by a certain Purchase Order Number? Currently, when I select the PO No. in the Invoice form, the products listbox show all products covered in other PO nos.

[markthomash3]

Sorry, I can't say from what you have said. Is this right: you recieve a PO from a customer and then make up an invoice, selecting the items from your list box? If you give 2 or 3 examples of the data for each part I might be able to see what you are asking.

[akmalkh]

Nice vedio 4Star

[5T3W4RT23]

Ahh Cheers soo much, 5/5

[RaviKings]

how can you do sums in a query to work out a total or be able to add a figure to a invoice.

[markthomash3]

Thank you for your kind remarks. These videos explain a simple way of making the invoice - there is a step-up from this, which is more practical, but more complicated. I hope I can find the time to add this later.

[ismeme]

I stumbled upon your video by accident whilst looking for an form/invoice example for Access 2003 and you answered many questions I had about how to produce an invoice from the displayed record. Now I'm off to check out your other related videos. Thank you so much!