Trying to create a format rule for one table based on info from another.
I tried the following but the format is being applied to all records not just the ones that have a blank check in date:
ISNOTBLANK(dbo.tblEvacuationRecord[CheckedInDate])
What am I missing?
So, this table that youโre trying to apply the formatting toโฆ Does it have a column in it that references this evacuation record? If so, it would need to be something like thisโฆ ISNOTBLANK([ref_column_name].[CheckedInDate])
Two tables:
Registration and Evacuation.
The evacuation table has the ref field back to Registration.
Iโm trying to put the format rule on the reg table.
With your expression how does it know to check the evac table?
@Grant_Stead just FYI CheckedInDate isnโt a column in the reg table.
but RegID is in both
@Tammi_Canelli itโs a standard derefference. You point to the column that references the other table, then โ.โ Look at the desired columnโฆ
Since youโre on a roll this morning.
Iโm still having trouble with this.
Since my reference is in the evac table back to registration and itโs the registration table Iโm trying to format based on a field in the evac table (that isnโt in the reg table), so I need to add a ref in reg to evac?
@Tammi_Canelli I wouldnโt add more columns than you need. You can run a lookup to the evac tableโฆ
ISNOTBLANK( LOOKUP([reg_key_column], evactable, evactable column, CheckedInDate) )
this only works if there is only one evac record per reg.
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |