Search results

Hi Again, GanzPopp, I'm not even really interested in which customers bought, only the number of customers that bought. I've taken you're query, displayed it as a pivot and then made the data a COUNT of CustomerName (which is already unique thanks to your query). This has done the buisness...

Hi All Again, the speed you guys come up with this stuff is amazing. Both the queries returned results of some kind but didn't quite shows what I was expecting (perhaps I wasn't very clear0. However, I have slightly adapted pr2-eugin's query to the following: SELECT ProductGroup...

Hi GanzPopp Firstly, thanks for such a fast response! I have tried your query and am recieving the following message: "You tried to execute a query that does not include the specified expression 'CustomerName' as part of an aggregate function" I'm about to Google this error but if you...

Hi All Thanks for taking the time to read my post. This is my problem. I have a table called SalesData that contains the following fields: - CustomerName - ProdCode - Qty - Turnover - SalesDate This table is simply a list of the products a customer has bought, how many they have bought...

...Just an additional point. If I remove the column "PrincipleACM" from the datasheet and then go into the form properties and remove the "AccountManagers" table from the Record Source, the problem goes away. If I then re-add the "AccountManagers" table to the Record Source, even if I don't add...

Hi All In simple terms, I have a call logging sheet that asks account managers to choose an account name from a list and then add details about a call before saving back to the 'CallSheet' table. There is an 'AccountManager' table that lists the names of all account managers. There is also a...

Hi Jzwp22 That's exactly it! I can't believe you have solved this so quickly. You guys really are an invaluable resource. Thank you thank you. Best wishes, Paul

Hi RJC. Perhaps I am missing something but if someone is "logged in" for 1.5 hours and they pick 346 lines. Then the number of lines per minute is 346/(1.5*60) = 3.84 (rounded to 2dp as in your query). In your query, you are dividing a number (believed to be total hours logged in) by 60...

Hi Everyone I'll just quickly say thanks to everyone to posts on this site. I've taken so many solutions away so far that I hope I'll be in a position to give something back at some stage. In the meantime, however, I have a problem that I'd really appriciate some help with. I'm using...

Hi Everyone I'm Paul from Lancashire in England. I'm the IT Manager for a manufacturing firm and I have a background (allbeit a long time ago) in programming using C++. Up until recently I used MS Excel and VBA to accomplish anything I needed but have recently taken the plunge into Access to...