Recent content by michaelxmas

Hi MStef/Lagbolt - thanks for the advice - not had internet access for a couple of days so just got chance to take a look at your help. I'll give it a go and let you know how I get on. Cheers. Mick

Hi - does anybody know if its possible to do a DCOUNT which counts the number of fields that include a given text. For example, instead of: DCount("*","Table1","Field1 = " & [Field2]) Can we use something that says?: DCOUNT("*","Table1","Field1 INCLUDES " & [Field2]) Can't find any...

ITS WORKED!! Awesome. You star. Solution was:.... Required: DCount("*","works order query availability","midpartsusedin = " & [midpack] & " AND nextwc = '" & [wcdes] & "'") Cheers! Mick

Brilliant-thanks - I'll give that a go. Instantly I can see a possible cause. my first criteria is numeric, my second text. So I'll try the 'string' format and let you know if it works.

Hi all. How's it going? I'm new here, but I like to think of myself as being reasonably good with Access. However, I'm totally stuck with a multiple DCOUNT and would really appriciate any advice... I'll give the formula, and the background is below if you're interested.... This works as a...

Ay up. I'm Mick from Yorkshire in the UK. I work in manufacturing and I've been using access for years now. I've developed quite a few systems in the past that have worked well, mostly for H&S and QA, (e.g. risk assessments, training records, complaints management) - so hopefully I can help...