Web Development

Ask something
Question Locked

Access Query

0 helpful
2 replies

by jim

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all, hoping you can help me with a probably simple task.
In running a query i would like to be able to submit any amount of a parameter to bring back all information related to one or many ObjectID's.

Any ideas how i can perform this task?
Sample code looks like

SELECT Field1, Field2, Field3
FROM Table1
HAVING Field1=[Production Tag]

So i would like to get the query back on any number of production tags. Any ideas?

2 replies

by tony hopkinson

SELECT Field1, Field2, Field3
FROM Table1
Where Field1 In('Tag1','Tag2',....,'Tagn')

The above can get a bit slow on large systems, an other way is to create another table mytags.
Insert the ones you want to ask about in to it and then join to it.

This discussion is closed to new replies.