Recent content by GordonB

Mile-O-Phile, Thank you for your response. However, I can't think how cascading comboboxes would've helped; I wasn't trying to select another particular company from the list, I wanted them all except one. Can you enlighten me a bit more, please? Jon K, That's perfect for my needs. I...

Hi mkelly. Yes. Company Name is the main company who contract out to several other companies. Think of the field name [Fruit]. In the criteria box for this field there will be two choices that come from the text box. One choice, for example" would be "apple" and the other choice would be...

Hi folks. Please, can someone put me out of my misery? On a form, I have a textbox. This value is used as criteria in a select query. I need it to do this: IIf([Forms]![Report Form]![Text268]="Company Name", then use "Company Name" as the criteria, but if the text box has "Other Companies"...

My thanks, Mile O Phile. I'll investigate further when I get a chance. Gordon.

Mile O Phile, I am a bit of a numpty really, and am learning all this as I go along, picking up lots of information from you and many others on this excellent site. However, would you tell me, in layman's terms, what you mean by normalising, please. Cheers, Gordon.

Maybe I'm reading the question wrong, but it looks like you want to count the number of times each check box is ticked. Make a new field name in the query for each checkbox field MyCountA:Sum(IIf([FieldNameA],1)) Press Sigma button on toolbar and change Group by to Expression. Run query