RowSource to get two or more values

[d9pierce1]

Hi all,
I have again spent most of the day tring to figure this out and going through the web.
I have tried it 100 different ways and yet I do not have a clue.
Would be greatful for some assistance...

The code below works fine to get one AccountTypeID but when I need two or more ID's I dont knwo what the ' " [ ( and all that stuff goes?


The Code below was just an example of the last thing I have tried....
I just cant figure out how to combine AccountType= 1 AND AccountType= 4 In WHERE Part

SELECT [qryAccountType].[AccountID], [qryAccountType].[AccountName], [qryAccountType].[AccountTypeID], [qryAccountType].[HelperValue] FROM qryAccountType WHERE [AccountTypeID]=1 AND [AccountTypeID]= 4 ORDER BY [HelperValue];

Thanks\
Dave

[ssanfu]

Change the AND to OR

WHERE [AccountTypeID]=1 AND [AccountTypeID]= 4

WHERE [AccountTypeID]=1 OR [AccountTypeID]= 4

You would not say "The truck is a Chevy AND a Ford".
You could say "The truck is a Chevy OR a Ford".


"AND" means both conditions MUST be TRUE.

"OR" means one or the other or both conditions can be TRUE

[d9pierce1]

Oh my heavens thank you so much\
I will mark this solved and make a not of this for future use\
Thanks
Dave