D
Daniel Wilson
My dbase records have 21 checkbox options for each record. I built a query
to retrieve only records who have the exact same checkboxes selected (true)
as those entered on a Query Parameter Form. I used the following statement
in the Criteria fields for my query in design view :
[Forms]![Search for AI - Vague]![checkbox name]Or[Forms]![Search for AI -
Vague]![checkbox name] Is Null
This query works fine and returns exactly what I am looking for, however,
once the query is saved...I am incapable of reopening it without freezing my
system and having to restart Access....I believe this may be because my query
is too complex as it contains a total of 23 similar criteria statements. Is
there any way to simplify this query so that I can reopen it when I need to
make adjustments? To date, every adjustment has required that I recreate the
query from scratch...which works...but in the end cannot reopen anyways.
to retrieve only records who have the exact same checkboxes selected (true)
as those entered on a Query Parameter Form. I used the following statement
in the Criteria fields for my query in design view :
[Forms]![Search for AI - Vague]![checkbox name]Or[Forms]![Search for AI -
Vague]![checkbox name] Is Null
This query works fine and returns exactly what I am looking for, however,
once the query is saved...I am incapable of reopening it without freezing my
system and having to restart Access....I believe this may be because my query
is too complex as it contains a total of 23 similar criteria statements. Is
there any way to simplify this query so that I can reopen it when I need to
make adjustments? To date, every adjustment has required that I recreate the
query from scratch...which works...but in the end cannot reopen anyways.