Search results

  1. M

    Question Send HYML emails from Access

    Hey, does anybody have any code that will allow HTML email to be sent directly from Access or does any one know of any cheap / free 3rd party programs that will do the same thing? Many thanks, Matt
  2. M

    Simple query issue - reqordset not updatable

    hi, i have a query which i have simplified for the purposes of fault finding which brings the error "the recordset is not updatable" whenever i try to change an item in the issues column. the sql query is below SELECT tblSupportCalls.IDSupportCalls...
  3. M

    Running total in query

    hi, I am trying to create a query that will allow me to catrgorise survey id's into different catchments. i have created the main part of the query but i am having issues creating a running total of the populations to categorise them by. the query is below and i need to have another field that...
  4. M

    Running total issue

    hi, trying to get a running total at the end of the following query with not much luck SELECT [2008_NSLSP_NF_P_RATES].NSLSP_id, [2008_NSLSP_NF_P_RATES].Postal_Sector, [2008_NSLSP_NF_P_RATES].Postal_Sector_Population, [2008_NSLSP_NF_P_RATES].[2007_Shopper_Population]...
  5. M

    Sum of column in query

    hi, just wondering if anyone could help with a small issue i have. i am trying to run the following query SELECT [2008_NSLSP_NF_P_RATES].NSLSP_id, [2008_NSLSP_NF_P_RATES].Postal_Sector, [2008_NSLSP_NF_P_RATES].Postal_Sector_Population, [2008_NSLSP_NF_P_RATES].[2007_Shopper_Population]...
  6. M

    "Query is too complex" error in Access 2007

    I am running a select query in Access 2007 which has relationships with 57 other select queries which sum up demographic and Acorn data. whenever i try to run the query i get the error "Query is too complex" but i have no idea where to start removing / shortening object names?? Any help would...
Back
Top Bottom