Search results

  1. W

    Pivot Table Help Required

    Dear All, I hope this makes sense as it's trick to explain but hoping someone can help. I have a pivot table with values in. The left hand heading are Job No. & Category, with month across the top and value £ as the data. The Job No has a total on it.... Job No Analysis Code...
  2. W

    Update Query

    Hi, I have a table I have an excel spreadsheet with fields such as name, account number and current balance. I also have a database which I have built. There are many fields within the database but it includes the above i.e Name, account Number and current balance. I have imported the...
  3. W

    Merging Tables

    I have 2 tables. The 1st table has many fields. The 2nd table has only 2 fields. The 2 fields in the 2nd table do appear in both tables. The second table has more up-to-date information and I want to merge these 2 fields from table 2 into table 1. How is the best way of doing this, so that only...
  4. W

    Exporting Report Data

    I have built a database and have around 30 reports each providing different statistics from the database. Is it possible to have all 30 reports run and the data exported to a spreadsheet by a click of a button. The data is things such as number of customers who did....during a month etc...
Back
Top Bottom