MS Access Expression required for data quality validation

[haaris195]

Hi,

I have a table with RAG and Schedule Start / Schedule End, I am trying to write an expression to check that every "G", "A" or "R" item has a Schedule Start and Schedule End.

Check: ([Roadmap]![RAG]="G", "A", "R" <[Scheduled Start] And [Scheduled End])

[ADezii]

The following Expression should equate to -1:

Check: [Roadmap].[RAG] In ('G','A','R') And Not IsNull([Schedule Start]) And Not IsNull([Schedule End])
 

[haaris195]

thanks but it asks for Parameter value?

[ADezii]

1. Sounds like a Syntax Error on the Field Name(s) and/or Table Name, are your Fields named?
   

   [RAG]
   [Schedule Start]
   [Schedule End]
    

2. Is your Table named Roadmap?
3. If not, substitute the correct Field Name(s) and/or Table Name.

[haaris195]

Yep - did that, replaced [Roadmap].[RAG] with [RAG], but still not working :(.

Do i have to define the [Schedule Start] & [Schedule End]; they are in the format of #DD/MM/YYYY# in the roadmap.

thanks again

[ADezii]

Can you Upload a small sample of the Database stripped of any sensitive info?

[haaris195]

actually it worked, think because i copied an pasted your script the fields weren't recognized properly, when i manually re-entered it, it worked. thanks a lot.

[ADezii]

You are quite welcome, good luck on your Project.