Does anyone know how to create a query in MS Access that will show me the average amount made on a sales transaction? The tables I'm given is inventory, sales, sales-inventory, customer and employee. I'm thinking it's ([quantity]*[unit price]/total amount of sales) or something like that but I'm thinking it's not suppose to be that easy lol. Thanks in advance for any help
Shit, it has been a year since I took a course in it and I did fairly well in it. But I just don't remember how to work it out, gotta think now..
