Search results for query: *

Brilliant Golom... Excellent result, I am very grateful. JimC :)

Thanks Golom Unfortunately I am an engineer trying to create a tool to check circuit outage conflicts and not a programmer. Any advice on how I can achieve my goal would be very welcome. In my head I know what result I want .... but as can be seen my lack of knowledge on sql is holding me back...

Thanks PHV, I tried SELECT dry_ehv_outage.JOB_ID, dry_ehv_outage.JOB_NUMBER, dry_ehv_outage.JOB_NAME, dry_ehv_outage.CCT, dry_ehv_outage.[RC1], dry_ehv_outage.[RC3], dry_ehv_outage.[RC5], dry_ehv_outage.[RC6] FROM dry_ehv_outage WHERE dry_ehv_outage.CCT in...

Hi, Challenge - check table for conflict between one field and several other fields. I am looking for a little assistance : I have a table which has a key field of JOB_ID and other general fields called CCT; RC1; RC2; RC3; RC4. I am trying to write a query that will create a table or report of...

Thanks PH - mist cleared ... I adapted your suggestion and got over my problem - sometimes the obvious just don't seem so obvious. JimC

Sorry if there was insufficient info on my question - I have a form which users access to approve jobs, there are six conditional check boxes that users check as the vaious job parameters are met - all I want to happen is the job approved check box to be set true when all other six check boxes...

On my application I am trying to automatatically set a yes/no field based on another five yes/no fields .. currently I run an update query from a control button, but there must be an easier way .. but I am blinkered out ... any advice? thanks JimC