Search results

Great works like a dream. You are a Star...... Many thx for yours help

Hi, I have been trying to solve from last 8 hours for part 2 but with out any luck, any further help will be appreciated. thx in advance

Many thx it work fine but the 2nd part of Q is remaining. My question is "query that displays the band name, the number of events that they have played at, the number of musicians in the band, the total amount earned by the band and the total amount earned by each band member (assuming that...

Hi, I manage to run Query, but im stuck how to group bands and price together then how to get each musician amount. thx in advance

**************************************************** Here is the screen shot of output after running SQL query. Now how do calculate each musician amount. Thanks for yours kind help

Any help...

many thx will update you soon

************************************************* Here is my attached database for yours kind consideration.

I have attached database file as well. Please let me know wht to do. yhx in advance.

soon will upload screen shots

try to show all my tables

I cant email or share screen shots

Im new here so cant post screen shots i need at least 10 post at least

Hi, Here is a situation I have one Musicians table with fields {unionNo PK, Surname, Forenames, Instrument} 2nd Event table with fields {Event Id PK, Price, Group, Venue, Band Name} 3rd Bandmembers table {BandName, UnionNo} 4th Band table {Band Name PK, Price} 5th Group table {Group PK...

Im getting big amount of sales figurs

I am really sorry that i actually didn't ask a Q as mentioned by you. Anyway next time i be more care full. I am try yours instruction if any thing comes up will let u know. Thx for help.

Design a query that displays the band name, the number of events that they have played at, the number of musicians in the band, the total amount earned by the band and the total amount earned by each band member (assuming that the fee is split equally). Please see the attached screen shot

Many thx it works. Great

I have a database of musical events. Now im creating flayers for each event. My Q is how the Information for each event should fit on one A4 page and should start on a new page of the report. Any help .....