Parameter Query query

[royfarnol]

Can one design a query that accepts a single user input and gets a combined
result out of two or more tables?

Thanks, Roy.

 

[Douglas J. Steele]

Yes, it's possible.

Unfortunately, with such a vague question as you posted, that's about as
specific an answer as you'll get.

 

[John W. Vinson]

Can one design a query that accepts a single user input and gets a combined
result out of two or more tables?

Thanks, Roy.

Yes.

 

[royfarnol]

Thanks. How would one achieve this?
Much obliged, Roy.

 

[John W. Vinson]

Thanks. How would one achieve this?
Much obliged, Roy.

By joining the two tables on some suitable linking field and putting a
criterion on one or more fields.

If you would like a more specific answer please post a more specific question,
such as describing the tables in question, their contents, and how they are
logically related.

 

[royfarnol]

I have several tables of Indo-European languages linked by a postulated
primitive root phoneme. Since most of these are presumptions this primitive
is arbitrarily represented in a form only really meaningful to myself.
Wishing to compare the various languages I wish to enter my root
symbolisation and get all the similar occurrences in the other language
tables.
I would like to know the Access method of doing this please. I know how to
do one table at a time but not several for one input.

Thanks, Roy.

 

[Douglas J. Steele]

Do you really expect people to help you if you're not going to cooperate
with us?

We're not clairvoyant!

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have several tables of Indo-European languages linked by a postulated
primitive root phoneme. Since most of these are presumptions this primitive
is arbitrarily represented in a form only really meaningful to myself.
Wishing to compare the various languages I wish to enter my root
symbolisation and get all the similar occurrences in the other language
tables.
I would like to know the Access method of doing this please. I know how to
do one table at a time but not several for one input.

Thanks, Roy.

 

[John W. Vinson]

I have several tables of Indo-European languages linked by a postulated
primitive root phoneme. Since most of these are presumptions this primitive
is arbitrarily represented in a form only really meaningful to myself.
Wishing to compare the various languages I wish to enter my root
symbolisation and get all the similar occurrences in the other language
tables.
I would like to know the Access method of doing this please. I know how to
do one table at a time but not several for one input.

By creating an appropriate query based on the structure of your tables.

You have not posted any information about the structure of your tables.

We cannot see your tables.

<shrug>

 

[royfarnol]

Now you are being rude. I shall unsubscribe from this newsgroup.
Roy.

I have several tables of Indo-European languages linked by a postulated
primitive root phoneme. Since most of these are presumptions this primitive
is arbitrarily represented in a form only really meaningful to myself.
Wishing to compare the various languages I wish to enter my root
symbolisation and get all the similar occurrences in the other language
tables.
I would like to know the Access method of doing this please. I know how to
do one table at a time but not several for one input.

Thanks, Roy.

 

[James A. Fortune]

I have several tables of Indo-European languages linked by a postulated
primitive root phoneme.

That's a very impressive use of Access.

Since most of these are presumptions this
primitive is arbitrarily represented in a form only really meaningful to
myself.

Since, in my estimate, a phoneme takes about 47 levels of optimized
neural net to model accurately, I agree that most models extant are
presumptuous.

Wishing to compare the various languages I wish to enter my root
symbolisation and get all the similar occurrences in the other language
tables.
I would like to know the Access method of doing this please. I know how
to do one table at a time but not several for one input.

If you include a field containing the name of the table, you can UNION
your tables (perhaps in several stages) and search them all
simultaneously, returning the table name as part of the results.

James A. Fortune
(e-mail address removed)

Minimizing communication entropy is analogous to packing spheres
optimally into three dimensional containers. -- JWK