help with table / query

[nahum abramovich]

Name: expression builder.jpg  Views: 8  Size: 176.5 KB  ID: 41769" class="thumbnail" style="float:CONFIG" />


i JUST need some TEXT to appear ON FORM when 4 condition (THAT COMES from query - LIKE THE EXAMPLE ABOVE) is met.


let say you have query [q] with 4 fields [a][b][c][d] and you want the word ATTENTION appear on your form if 4 [q] conditions is true? how do you do this?

[nahum abramovich]

hi

but i want values come from the query ....

i will try and let you know

thank you

[CJ_London]

if it is to come from a query and not from fields in your form, use dcount

=iif(dcount("*","[q]","[a]='Danny' And [b]='Triangular' And [c]='Red' And [d]>1")>0,"ATTENTION","")

[nahum abramovich]

i tried - no success

[CJ_London]

'no success' does not help us to help you. With a naming convention like 'q', 'a' etc I suspect you have issues there. Clarify exactly what you have - sql to your form recordsource, sql to your 'q' query

[nahum abramovich]

very gooooooddddd mf

thank you very much it worksssssss =iif(dcount("*","[q]","[a]='Danny' And [b]='Triangular' And [c]='Red' And [d]>1")>0,"ATTENTION","")