Search results

  1. P

    SELECT DISTINCT and COUNT DISTINCT

    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...
  2. P

    Could not find the field '...'

    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...
  3. P

    Automatic selection of items in a list

    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...
  4. P

    Morning All

    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...
Back
Top Bottom