Microsoft Access ® 2003 Sales Invoice: 3 Report

[account2258]

You have a sooothing voice!

[fjilfaz]

Thanks for your video!

[aniggnigg]

if you want to show dates for a specific date range using the design query.. how do u do that???????/

[markthomash3]

@aniggnigg To show only those orders for a specified range of dates 1. Open query in design view. 2. In criteria row of date field, Between xx/xx/xxxx and xx/xx/xxxx should do the trick.

[moosickle]

I use these guys . foxblue.com.au/products/foxbil­l.php (free!) awesome, just awesome

[mikeandpetra]

This is all very well but without the invoice number it's useless.

[mikeandpetra]

This is all very well but without the invoice number it's usless.

[mikeandpetra]

No Invoice NR. ???

[MrlRight]

Thanks for the tutorial. What about the invoice number? How get that to be created when it's coming from different records?

[markthomash3]

@MrlRight

This series of videos is based on a beginner's simplified sales system - it is cut to the minimum to help novices. However, to get an invoice number you would need to introduce 1. a new entity/table - tblOrder(OrderId, Date, fkCustomerID). 2. tblOrderLine(fkOrderID, fkStockId). You will find this structure in the Microsoft Northwind example database. The OrderId set as Autonumber will give you a unique number to use on the invoice. Hope that helps.

[paraglide01]

Very good tutorial, have been trying to make a report linked to a customer-order form for ages  and your way is so logical. Thank you very much.

[Omega231984]

Keep em coming, I took a college course on this software, and my instructor sucked, he didn't even know how to use it, and of course I failed

[Lethalng3l]

yuh hav no idea how big a help this was!

thank u very much