Search results

Thanks guys, had a great day with my family and my young grand kids beat the c**p out of me in a cushion fight as a special treat. :confused: :D Brian

Yes happy birthday to our old friend Cindy, although she is not around often these days. Brian

You don't say where this is coming from, if Access then the simplest approach would be to do the aggregation in the Access query. Brian

The answer to the question is yes, the data is only available when you move off the control IE textbox or hit enter. Brian

I don't think you can use average ifs here , I think that you are going to need to do 4 counts, three countifs to get he number of True with each position and a count of all the True, then do the maths. Brian

The thread that you are thinking of is probably this http://www.access-programmers.co.uk/forums/showthread.php?t=274539&highlight=Visible But whether it helps I am not sure. Brian

What does Oy mean? Brian

Puzzled as to why my link does not point at a solution to your problem, IE wild cards in joins. Brian

I'm always amused when people say a function does not work when they mean that they cannot use it . You might like to take a look at this http://www.utteraccess.com/forum/index.php?showtopic=1888759 Brian

By that definition number 2 was wasted. :D Brian Ps for the record I enjoyed them.

Rze: Double Word Punnies I think that was a groan of pain;) Brian

K is the chemical symbol for potassium Brian

I no longer have Access so this will probably be my only response. If you have just 3 predefined % then 3 simple queries would seem the way to go rather than using VBA to build a SQL string obtaining the value from the form to put into that string. Brian

Glad to have helped and pleased that you could expand on the info. Brian

Got me there, he was the last noun so my pronoun would refer to him, but no I meant Roy Orbison. Brian

And now you are an annoying old tit, which means being down South correct. :D Brian

Mark to save typing in the future you may like to know that those plastic ends are called aglets. Brian

Saw him live, very impressive. Brian

Eg sheets("sheet2").Range("C2")=sheets("sheet1").range("A1") If you are doing a lot of such coding then Dim sh1 as worksheet Set sh1 = sheets("sheet1") Then you can code sh1.Range("A1") Brian

Abbreviations and achronyms are common and used by us all, think MODEM RADAR it's local idioms that can be the problem, but in this case anybody with a brain cell following the thread would have known whom Dick was alluding to. Brian