Search results

  1. W

    Splitting Data into seperate columns

    Hey all, I have been given the task of organising a mail-merge with a sharepoint list, but the names and emails attached to each object are seperated by a delimiter. Furthermore each person is associated with many objects, and they want the merge programmed to only send 1 email to each person...
  2. W

    Database design help!

    Hey all, Am currently planning the re-design of a database I made for work. It was buggy, over-complex and I am hoping that you might be give me some help about how to get around a few of the errors I encountered last time. Be warned I am very new at this. Firstly, is there a way of getting...
  3. W

    Is there an easy way to post table structure (SQL equivalent?)

    Hey all, I would love to ask for some help structuring my database but my table structure takes some explaining, is there an easier way of posting this information? Cheers, Greg
  4. W

    Combining 'Make Table' with Union Queries

    Hey all, Wondering whether it is possible to use the 'Make Table' function in conjunction with a union query. My early attempts have failed and I am relatively new to Access. I am using Access 2010. Thanks in advance, Greg
  5. W

    Getting around the 'Query is too complex' issue

    Hey All, Recently ran into the 'Query is too complex' error while entering data into my database when attempting to run the following query: TRANSFORM Count([Summary of Tests].Status) AS CountOfStatus SELECT [Application List].[TC or #], [Application List].[Test Object], IIf([Test Status...
  6. W

    Strange Union Query Error

    Hey guys, Getting a weird error where my union query is scrambling the data under different headings.... SQL is below. I know its absolutely terribly designed, but I'm kinda new to this stuff, and definitely open to advice! SELECT [Application List].[TC or #], [Application List].[Test...
Back
Top Bottom