Jump to content

worksheet criteria for exterior door schedule


Recommended Posts

I am trying to create separate door schedules for interior and exterior doors, but I am having trouble with the criteria settings to get the worksheet to function properly.

The criteria I have currently looks something like this:

Layer is 0-Basement

Record Door is present

Field Value On Schedule = TRUE

Field Value Location = EXTERIOR

It seems that the last piece of criteria is not being used. No matter what I type in for the Location field, it will not cull out the doors that say "interior"

Am I missing something, or should they be in a different order?

Link to comment

I think this is a problem with the GUI in the database criteria.

The worksheet interprets your criteria like this:

Layer is 0-Basement


Record Door is present


(Field Value On Schedule = TRUE OR Field Value Location = EXTERIOR)

It only needs one field value to be true.

There's no way in the Edit Criteria dialog box to choose if you want both field values or either one.

The way to fix it is to get to that Edit Criteria… dialog box.

Click Cancel.

Look in the formula bar. It will say something like = DATABASE(…

Look for the part that says

(('Door'.'OnSched'=TRUE) | ('Door'.'Location'='Interior'))))

Change the '|' to '&'

[in logic speak, '|' (called a pipe) = OR and '&' (ampersand) = AND]

That will force the database criteria to select doors that have BOTH 'on schedule' and Interior

Keep an eye on it. I haven't kept track of what future changes in the database criteria will cause it to revert back to '|'. But it can happen.



Link to comment
  • 4 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...