L
la knight
Hello!
I have a report which is based upon a query as it's record source. It is
called "Query_BOM_U". In this query it displays 8 different fields which may
or may not have data (meaning some of the fields might be blank for certain
records). The field names would be like this NAME, NUMBER, NAME1, NUMBER1,
NAME2, NUMBER2, NAME3, NUMBER3. My query results in dataview format show all
the records I need except I need them filtered to display in the detail
section as records based upon certain criteria and I'm not sure which type or
syntax to use and have recieved #error when trying different things.
For instance: I need to display these fields as a source or filter into one
text box...
NAME if NUMBER="20" Or NAME1 if NUMBER1="20" Or NAME2 if NUMBER2 ="20" Or
NAME3 if NUMBER3="20"
Any help is much appreciated!
I have a report which is based upon a query as it's record source. It is
called "Query_BOM_U". In this query it displays 8 different fields which may
or may not have data (meaning some of the fields might be blank for certain
records). The field names would be like this NAME, NUMBER, NAME1, NUMBER1,
NAME2, NUMBER2, NAME3, NUMBER3. My query results in dataview format show all
the records I need except I need them filtered to display in the detail
section as records based upon certain criteria and I'm not sure which type or
syntax to use and have recieved #error when trying different things.
For instance: I need to display these fields as a source or filter into one
text box...
NAME if NUMBER="20" Or NAME1 if NUMBER1="20" Or NAME2 if NUMBER2 ="20" Or
NAME3 if NUMBER3="20"
Any help is much appreciated!