If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional format - Check for valid values
I have a query that return values from a table. These fields should
all be filled with data, but some are not, and some are filled with wrong data. I need to have my users validate the data in this form. I am currently using conditional format and using yellow background to make the NULL values stand out. I'd like to have the fields with non- valid data have red text. I'm not sure how to write the expression for that in the conditional format setup. Here's the query the form is based on. I need to mark the [tag]! [function_code] control with red text when it has a value that does not exist in the [WM_GOC_Conversion]![Function_Code] field SELECT Tag.Tag, Tag.Description, Tag.Tag_cat, Tag.Function_code, Tag_diverse.Disiplin, Tag.System, Tag_diverse.Comm_Pkg, Tag.Area, [Tag_format_in/_br/_te].Fire_area, Tag.Loop, WM_GOC_Conversion.Function_code FROM ([Tag_format_in/_br/_te] INNER JOIN (WM_GOC_Conversion RIGHT JOIN Tag ON WM_GOC_Conversion.Function_code = Tag.Function_code) ON [Tag_format_in/_br/_te].Tag = Tag.Tag) INNER JOIN Tag_diverse ON Tag.Tag = Tag_diverse.Tag WHERE (((WM_GOC_Conversion.Function_code) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Loop) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Description) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Tag_cat) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Function_code) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag_diverse.Disiplin) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.System) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag_diverse.Comm_Pkg) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Area) Is Null) AND ((Tag.Flag) Is Null)) OR ((([Tag_format_in/ _br/_te].Fire_area) Is Null) AND ((Tag.Flag) Is Null)); |
#2
|
|||
|
|||
Conditional format - Check for valid values
Never mind, I figured it out! :-)
atledreier wrote: I have a query that return values from a table. These fields should all be filled with data, but some are not, and some are filled with wrong data. I need to have my users validate the data in this form. I am currently using conditional format and using yellow background to make the NULL values stand out. I'd like to have the fields with non- valid data have red text. I'm not sure how to write the expression for that in the conditional format setup. Here's the query the form is based on. I need to mark the [tag]! [function_code] control with red text when it has a value that does not exist in the [WM_GOC_Conversion]![Function_Code] field SELECT Tag.Tag, Tag.Description, Tag.Tag_cat, Tag.Function_code, Tag_diverse.Disiplin, Tag.System, Tag_diverse.Comm_Pkg, Tag.Area, [Tag_format_in/_br/_te].Fire_area, Tag.Loop, WM_GOC_Conversion.Function_code FROM ([Tag_format_in/_br/_te] INNER JOIN (WM_GOC_Conversion RIGHT JOIN Tag ON WM_GOC_Conversion.Function_code = Tag.Function_code) ON [Tag_format_in/_br/_te].Tag = Tag.Tag) INNER JOIN Tag_diverse ON Tag.Tag = Tag_diverse.Tag WHERE (((WM_GOC_Conversion.Function_code) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Loop) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Description) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Tag_cat) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Function_code) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag_diverse.Disiplin) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.System) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag_diverse.Comm_Pkg) Is Null) AND ((Tag.Flag) Is Null)) OR (((Tag.Area) Is Null) AND ((Tag.Flag) Is Null)) OR ((([Tag_format_in/ _br/_te].Fire_area) Is Null) AND ((Tag.Flag) Is Null)); |
Thread Tools | |
Display Modes | |
|
|