Recent content by deanaldo

Bump, can anyone help at all?

Hi, I want to create a query that shows all repairs done by an engineer and how many tubes were installed by an engineer for each job over a specified date. I want to display every job the engineer has done and then at the end of their jobs I want a total of how many tubes they have installed...

Thanks, this worked great:)

Hi, I am trying to set up a cross tab query to show the best performing advert per area. I want it to show up like this: Advert England Scotland Wales Website 45 21 8 Word of Mouth 189 75 24 Newspaper 124 14 5 etc. Instead it comes out like this: Advert England Scotland Wales...

Thanks for both of your help, got it working now

Hi, Having a few problems with a query which I am trying to get a count but its counting against the wrong thing if that makes sense. I am trying to run a query to show how many customer a salesperson has booked in. All the data is being pulled from one table. I am pulling 3 fields...