Recent content by yorkshirepudding

  1. Y

    Two queries work fine, but joined together get error

    Hi As no-one had any quick solutions, I went back to basics and thought about how I could do this purely on simple queries with no sub queries. I have now done that and it works. For reference and for the benefit of anyone coming across this by google with a similar issue, here is what I did...
  2. Y

    Creating unique rows in one column of query

    HI The quickest way would be to do 3 queries: 1. Total sales grouped by property code SELECT GL_SalesPayment_Tbl.PropertyCode, Sum(GL_SalesPayment_Tbl.TransactionAmount) AS SumOfTransactionAmount FROM GL_SalesPayment_Tbl GROUP BY GL_SalesPayment_Tbl.PropertyCode; 2. Total gains/losses grouped...
  3. Y

    Creating unique rows in one column of query

    Check your post. This doesn't look like a query and it is hard to read as a table. Do you have the SQL that these figures come from? Cheers yorkie
  4. Y

    Two queries work fine, but joined together get error

    Hi I am in the process of building a reporting tool in Access, pulling together data from another database and from a web database (via emailed reports). It is mostly going fine with queries working as supposed to. However, when I try and combine two moderately complex queries, I get the...
  5. Y

    Greetings from up north

    Hello I am based in the North East of England and do MS access work as part of my job in the civil service managing management information and business systems. I also do bits of freelance workin my spare time, along with motorbikes, kids and family. Cheers Martin
See more
Back
Top Bottom