how do i use the in operator to sort by type?

[ladytiger]

I am trying to use the in operator to create a query based on type, title,
and issue. its for any business, law, or political articles and needs to be
sorted by type. i am typing it as in ("political", "law", "business"). am i
typing it wrong? can someone show me how it should be typed? i'm suppose to
run the query and come back with 16 articles using the in operator.

 

[Jack Cannon]

Marquis,

There is not enough information in your post for anyone to make a valid
response to your question.

Try posting the actual SQL text and if the query is a Parameter Query
identify which field(s) that you are typing in the data.

Jack Cannon

 

[John W. Vinson]

I am trying to use the in operator to create a query based on type, title,
and issue. its for any business, law, or political articles and needs to be
sorted by type. i am typing it as in ("political", "law", "business"). am i
typing it wrong? can someone show me how it should be typed? i'm suppose to
run the query and come back with 16 articles using the in operator.

I wonder if you're misusing terminology here? To "Sort" means to "put records
into a particular sequential order", and the In() operator has nothing to do
with sorting - sorting is done using the Order By clause of a query.

It sounds like you're posting a homework question; you might want to read your
course materials, or ask your teacher. At the very least post the SQL of your
query and some more details about the question.