Sorry, I have a really basic understanding of Access...
I want to be able to use multiple conditions to pull specific data for my query. I know how to use the "where" in expression builder, and my understanding is that if i use multiple "wheres" I will be creating "AND" STATEMENTS.
I want to know how to create a query based on conditional "OR" STATEMENTS across multliple variables.
For example- if varable1=x OR variable2=x OR variable3=x then include the record. Is that possible to do? I know very little SQL...
I want to create a query that gets demographic data from the table "participant enrollment information" but only if they entered one of the 7services (FS, FL, IDA, REAP, SSHF, CD DVRP) during a specific timeframe.
FSenterdt1 is between 1/1/2009 3/31/2009 OR FSenterdt2 is between 1/1/2009 3/31/2009 etc.
Sorry if it is unclear. I don't know how to better explain my dilemma.
I can email the database if that is easier too..