Search results

Hi there, My dilemma is deciding if setting up my particular data in separate tables would be beneficial or make revising this data on an as needed basis by an end user more complicated than if were to store the data in one table. My data is approx. 50 different records retention periods, which...

Calling all experts! I need your help! I need to create conditional formatting (like highlighting) for multiple field values that do not match in my report that is based on a Union All query. First, you might need to know that my Union All query (detail below) returns all rows in tables A and...

Hello there, I’d like to combine the text values from multiple fields from one table in one new field, for each record, and null values are involved. There are really a dozen fields to combine, but to make discussion easier, let’s say I have 6 fields to combine: Expr1 Expr2 Expr3 Expr4 Expr5...

Hi! I am having trouble with a formula in the Update to: of my update query. I can get it to update a date field in the underlying table with this formula: DateAdd("yyyy",([table1]![Number1]+[table1]![Number2]),[table2]![Date]) but, if a check box in another field is checked, I want the...