Recent content by claris

WHAT!?!? I tried CStr first and it didn't work!!! Now it has! How odd, perhaps changing the query column format and Cstr just bumped it. Cheers guys - Mr Q - you rule =]

Tell me about it! It's set to fixed, zero decimal places.

Yep, still doesn't like it, but thanks!

Thanks WayPay but it's a field within the export which is 'growing' a decimal, not the format of the dates.

Hi people I have a standard csv export which is adding decimal places to a field which needs to be standard. I have tried all the normal ways of stopping this (setting the field format within the query and data build itself) and am now stuck as to what else to do. It seems it is ok when...

Hello Yeh I sorted this one about ten minutes after I posted, must have been Friday brain malfunction, but thanks for your time and help. I did it in a slightly different way, Dim'ed a load of fields, with dlookups for the values, and added them in, in a particularly long string of .body =...

Hi All I am running a module out of Access, and want to include the results of two queries in the body of the email, as well as attaching an attachment. Currently I have - If audit = "Y" Then DoCmd.Close acQuery, "AUDITSUMFINAL" DoCmd.Close acQuery, "AUDITSUMFINALCUST" Set App =...