Forum Discussion

HUlm1's avatar
HUlm1
Helper I
6 years ago
Solved

Any One Instance / At least One

Hi, I have three tables:  "purchase orders" ; "jobs" and "quotations"   In "quotations" I have a Yes/No column which shows whether a Job requires materials from our Parent Company (lets call them A...
  • fhill's avatar
    fhill
    6 years ago

    There's probably a smoother way of doing it, but I just COUNT'ed "YES" for each PO, and if that COUNT was > 0, then 'YES Present' else 'Yes Not Present'.

    FOrrest

     

     

fhill's avatar
fhill
Resident Rockstar
6 years ago

There's probably a smoother way of doing it, but I just COUNT'ed "YES" for each PO, and if that COUNT was > 0, then 'YES Present' else 'Yes Not Present'.

FOrrest

 

 

HUlm1's avatar
HUlm1
Helper I
6 years ago

Brilliant!  Thankyou.  Worked a treat