Search results

I currently have a database which I believe is in 3NF. It's completed as such, but I have recently come accross normalization methods. Because of this I would like to know how my 3NF tables could look in 0NF, 1NF and 2NF. For both the purpose of ensuring the database is correct now, and for...

Hey, I have an orders form, which makes the orders, but I would also like to be able to search back through old orders to append them in the same form. Currently I have frmOrders, which has a combo for the customersID (which then adds their details to fields). In this form I also have...

Aha! It is now working. I had to add the actual book to the query with it! This now means an artist can appear more than once in a month, but it's much more flexible as it can give reports into such details as royalties per books (which can easily be combined for report form!) I'm sure...

The code was actually from what I built, I'm not that good with SQL...haha. The problem is the sum is relating to the month, and not the Author. So all Authors will appear under the same month with the combined amount they are all owed. Thanks.

Excellent, that seems just what I want! One slight problem at the moment is this: The royalty section is adding up EVERY order, and not just the ones of the related Author. Code: SELECT tblAuthors.lngAuthorID, tblAuthors.strAuthorName, Sum(([curUnitPrice]*0.25)) AS Royalty...

Thanks for the quick response. So the query would record a sum of each Author for each month? So it would be something like: R. Dahl - Jan - £40 D. Brown - Jan - £45 R. Dahl - Feb - £25 D. Brown - Feb - £45 etc. etc. Would this have to be written in SQL? Thanks again, Lana.

Hi guys, I have constructed a database which is basically sales related. It is basically used for keeping tracks of Books, where the artist gets royalties. I want to, in the most logical way (perhaps a monthly report) be able to keep track of how much the Author of the book is owed. All of the...