Recent content by mattsteele8

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

thanks for your replies any one have a fix for the query or a work around that means that i will not have to use the group by clause. I have been asked to use the dsum so i will try and write an expression that incorporates that

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

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

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]...

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]...

leigh, thank you so much for the help with the massive horrible query that i had created. working perfectly now!!

hi leigh, just thinking out loud now and i will probably have proved myself wrong in the time it takes you to get back to me but can i not use a where clause to exclude the acorn type 0 i.e. WHERE ArotnType <> 'Acorn Type 0' thanks again for you help

LPurvis thank you so much, that works almost perfectly. the only thing that isn't right is that when it adds the acorn type columns it adds an 'Acorn Type 0' column. i am not sure where it is getting this value from as there are no columns titled acorn type 0 in the tblAmendedUKPostcodes table...

hi and cheers for your quick reply, the answer is that i have done it this way because i am not that experienced with access and could not think of another way to do it. each of the 57 queries is a filter and sum on the tblAmendedUKPostcodes table to to find out the total population of a...

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