I need help writing a query

[Chris]

Backround Setup:

I have a database that consists of different tables. Each table is basicly
a two column list. The final table in the database is basically a
colaboration of all the other tables. In other words I am using the lists
from the other tables in this final table. In this final table information
gets repeated more than once depending on how the information relates to
eachother.

One of the columns is a name field. The name may be repeated multiple times
depending on how it is related to the other information.

What I am wanting to do is run a query that is based on this final table. I
would like for the query to prompt me for a name, when I type the name I
would like it to bring up all the information from that last table that
relates to that name. I am having problems figuring this out. I am sorta
new to Access and I only have a very basic understanding of the software. If
someone could please help me I would greatly appreciate it.

 

[Dale Fye]

Chris,

1. Could you provide us with some sample data from a couple of your tables
(include the table name, field names, and a couple of records)?
2. Then show use a what a couple of records (the same ones as the ones you
show is in step #1) would look like in the "master" table

Generally, when you find yourself trying to combine data from multiple
tables into some sort of master table, it is an indication that you have more
tables than you need. In your particular case, I think you would probably be
better off with the one "master" table with an additional field in that table
that indicates some property of the record that would equate to the table it
comes from (getting a look at the structure of your tables will validate or
invalidate this statement).

 

[Chris]

I receated a database that is similiar to the one that I am working with.
(The information is a little sinsitive) is there an e-mail or something tha I
might be able to send the replica database so that you can just look at it
that way?

 

[Bob Barrows]

Backround Setup:

I have a database that consists of different tables. Each table is
basicly a two column list. The final table in the database is
basically a colaboration of all the other tables. In other words I am
using the lists from the other tables in this final table. In this
final table information gets repeated more than once depending on how
the information relates to eachother.

One of the columns is a name field. The name may be repeated
multiple times depending on how it is related to the other
information.

What I am wanting to do is run a query that is based on this final
table. I would like for the query to prompt me for a name, when I
type the name I would like it to bring up all the information from
that last table that relates to that name. I am having problems
figuring this out. I am sorta new to Access and I only have a very
basic understanding of the software. If someone could please help me
I would greatly appreciate it.

Enter this into the criterion row of the name column in the query grid:

[Enter Name]

Run the query and you will be prompted to enter the name.

 

[Chris]

I have tried that and it doesn't filter the name or it gives me an error.

Backround Setup:

I have a database that consists of different tables. Each table is
basicly a two column list. The final table in the database is
basically a colaboration of all the other tables. In other words I am
using the lists from the other tables in this final table. In this
final table information gets repeated more than once depending on how
the information relates to eachother.

One of the columns is a name field. The name may be repeated
multiple times depending on how it is related to the other
information.

What I am wanting to do is run a query that is based on this final
table. I would like for the query to prompt me for a name, when I
type the name I would like it to bring up all the information from
that last table that relates to that name. I am having problems
figuring this out. I am sorta new to Access and I only have a very
basic understanding of the software. If someone could please help me
I would greatly appreciate it.

Enter this into the criterion row of the name column in the query grid:

[Enter Name]

Run the query and you will be prompted to enter the name.

 

[Bob Barrows]

You're not giving me much to go on. Show me some sample data (it does
NOT have to be real data - just a few rows of falsified data so I can
see the relevant field names and data that is isimilar to the actual
data), then follow that with the results you want the query to retrieve
(again, in tabular format).

I have tried that and it doesn't filter the name or it gives me an
error.

Backround Setup:

I have a database that consists of different tables. Each table is
basicly a two column list. The final table in the database is
basically a colaboration of all the other tables. In other words I
am using the lists from the other tables in this final table. In
this final table information gets repeated more than once depending
on how the information relates to eachother.

One of the columns is a name field. The name may be repeated
multiple times depending on how it is related to the other
information.

What I am wanting to do is run a query that is based on this final
table. I would like for the query to prompt me for a name, when I
type the name I would like it to bring up all the information from
that last table that relates to that name. I am having problems
figuring this out. I am sorta new to Access and I only have a very
basic understanding of the software. If someone could please help
me I would greatly appreciate it.

Enter this into the criterion row of the name column in the query
grid:

[Enter Name]

Run the query and you will be prompted to enter the name.

 

[Chris]

I have made a moc database. Is there an e-mail that I can just send it to
you? I have been asking people for help without getting much back.

You're not giving me much to go on. Show me some sample data (it does
NOT have to be real data - just a few rows of falsified data so I can
see the relevant field names and data that is isimilar to the actual
data), then follow that with the results you want the query to retrieve
(again, in tabular format).

I have tried that and it doesn't filter the name or it gives me an
error.

Chris wrote:
Backround Setup:

I have a database that consists of different tables. Each table is
basicly a two column list. The final table in the database is
basically a colaboration of all the other tables. In other words I
am using the lists from the other tables in this final table. In
this final table information gets repeated more than once depending
on how the information relates to eachother.

One of the columns is a name field. The name may be repeated
multiple times depending on how it is related to the other
information.

What I am wanting to do is run a query that is based on this final
table. I would like for the query to prompt me for a name, when I
type the name I would like it to bring up all the information from
that last table that relates to that name. I am having problems
figuring this out. I am sorta new to Access and I only have a very
basic understanding of the software. If someone could please help
me I would greatly appreciate it.

Enter this into the criterion row of the name column in the query
grid:

[Enter Name]

Run the query and you will be prompted to enter the name.

 

[Bob Barrows]

No, email is reserved for paying customers, and I don't do Access paid
work anymore.

You're not getting much help because you're not helping us help you. I'm
not only talking about the lack of sample data: how are we supposed to
know what you're doing wrong if you describe your symptom as only "an
error"? Gee, that's helpful ...

And showing us the sql statement that led to the error would really help
as well ... switch your query to SQL View and copy/paste the statement
into your message. That may relieve you of the need to post some sample
data and intended results, but it can't hurt to show sample data and
intended results.

I have made a moc database. Is there an e-mail that I can just send
it to you? I have been asking people for help without getting much
back.

You're not giving me much to go on. Show me some sample data (it does
NOT have to be real data - just a few rows of falsified data so I can
see the relevant field names and data that is isimilar to the actual
data), then follow that with the results you want the query to
retrieve (again, in tabular format).

I have tried that and it doesn't filter the name or it gives me an
error.

:

Chris wrote:
Backround Setup:

I have a database that consists of different tables. Each table
is basicly a two column list. The final table in the database is
basically a colaboration of all the other tables. In other words I
am using the lists from the other tables in this final table. In
this final table information gets repeated more than once
depending on how the information relates to eachother.

One of the columns is a name field. The name may be repeated
multiple times depending on how it is related to the other
information.

What I am wanting to do is run a query that is based on this final
table. I would like for the query to prompt me for a name, when I
type the name I would like it to bring up all the information from
that last table that relates to that name. I am having problems
figuring this out. I am sorta new to Access and I only have a
very basic understanding of the software. If someone could
please help me I would greatly appreciate it.

Enter this into the criterion row of the name column in the query
grid:

[Enter Name]

Run the query and you will be prompted to enter the name.

 

[Chris]

I have done all this before. If you are willing to take a second and look
back at August 14, 2009 there was a question post there with the name Access
Query and it has 24 posts on it. All the information that you would be
looking for is posted on there. When the person that was helping me didn't
get back I thought that I would post the question again and see if there was
something someone else could help me with.

No, email is reserved for paying customers, and I don't do Access paid
work anymore.

You're not getting much help because you're not helping us help you. I'm
not only talking about the lack of sample data: how are we supposed to
know what you're doing wrong if you describe your symptom as only "an
error"? Gee, that's helpful ...

And showing us the sql statement that led to the error would really help
as well ... switch your query to SQL View and copy/paste the statement
into your message. That may relieve you of the need to post some sample
data and intended results, but it can't hurt to show sample data and
intended results.

I have made a moc database. Is there an e-mail that I can just send
it to you? I have been asking people for help without getting much
back.

You're not giving me much to go on. Show me some sample data (it does
NOT have to be real data - just a few rows of falsified data so I can
see the relevant field names and data that is isimilar to the actual
data), then follow that with the results you want the query to
retrieve (again, in tabular format).

Chris wrote:
I have tried that and it doesn't filter the name or it gives me an
error.

:

Chris wrote:
Backround Setup:

I have a database that consists of different tables. Each table
is basicly a two column list. The final table in the database is
basically a colaboration of all the other tables. In other words I
am using the lists from the other tables in this final table. In
this final table information gets repeated more than once
depending on how the information relates to eachother.

One of the columns is a name field. The name may be repeated
multiple times depending on how it is related to the other
information.

What I am wanting to do is run a query that is based on this final
table. I would like for the query to prompt me for a name, when I
type the name I would like it to bring up all the information from
that last table that relates to that name. I am having problems
figuring this out. I am sorta new to Access and I only have a
very basic understanding of the software. If someone could
please help me I would greatly appreciate it.

Enter this into the criterion row of the name column in the query
grid:

[Enter Name]

Run the query and you will be prompted to enter the name.

 

[Chris]

Were you able to find the old post?

No, email is reserved for paying customers, and I don't do Access paid
work anymore.

You're not getting much help because you're not helping us help you. I'm
not only talking about the lack of sample data: how are we supposed to
know what you're doing wrong if you describe your symptom as only "an
error"? Gee, that's helpful ...

And showing us the sql statement that led to the error would really help
as well ... switch your query to SQL View and copy/paste the statement
into your message. That may relieve you of the need to post some sample
data and intended results, but it can't hurt to show sample data and
intended results.

I have made a moc database. Is there an e-mail that I can just send
it to you? I have been asking people for help without getting much
back.

You're not giving me much to go on. Show me some sample data (it does
NOT have to be real data - just a few rows of falsified data so I can
see the relevant field names and data that is isimilar to the actual
data), then follow that with the results you want the query to
retrieve (again, in tabular format).

Chris wrote:
I have tried that and it doesn't filter the name or it gives me an
error.

:

Chris wrote:
Backround Setup:

I have a database that consists of different tables. Each table
is basicly a two column list. The final table in the database is
basically a colaboration of all the other tables. In other words I
am using the lists from the other tables in this final table. In
this final table information gets repeated more than once
depending on how the information relates to eachother.

One of the columns is a name field. The name may be repeated
multiple times depending on how it is related to the other
information.

What I am wanting to do is run a query that is based on this final
table. I would like for the query to prompt me for a name, when I
type the name I would like it to bring up all the information from
that last table that relates to that name. I am having problems
figuring this out. I am sorta new to Access and I only have a
very basic understanding of the software. If someone could
please help me I would greatly appreciate it.

Enter this into the criterion row of the name column in the query
grid:

[Enter Name]

Run the query and you will be prompted to enter the name.

 

[Bob Barrows]

Yes, and I replied in that thread.

Were you able to find the old post?

No, email is reserved for paying customers, and I don't do Access
paid work anymore.

You're not getting much help because you're not helping us help you.
I'm not only talking about the lack of sample data: how are we
supposed to know what you're doing wrong if you describe your
symptom as only "an error"? Gee, that's helpful ...

And showing us the sql statement that led to the error would really
help as well ... switch your query to SQL View and copy/paste the
statement into your message. That may relieve you of the need to
post some sample data and intended results, but it can't hurt to
show sample data and intended results.

I have made a moc database. Is there an e-mail that I can just send
it to you? I have been asking people for help without getting much
back.

:

You're not giving me much to go on. Show me some sample data (it
does NOT have to be real data - just a few rows of falsified data
so I can see the relevant field names and data that is isimilar to
the actual data), then follow that with the results you want the
query to retrieve (again, in tabular format).

Chris wrote:
I have tried that and it doesn't filter the name or it gives me an
error.

:

Chris wrote:
Backround Setup:

I have a database that consists of different tables. Each table
is basicly a two column list. The final table in the database
is basically a colaboration of all the other tables. In other
words I am using the lists from the other tables in this final
table. In this final table information gets repeated more than
once depending on how the information relates to eachother.

One of the columns is a name field. The name may be repeated
multiple times depending on how it is related to the other
information.

What I am wanting to do is run a query that is based on this
final table. I would like for the query to prompt me for a
name, when I type the name I would like it to bring up all the
information from that last table that relates to that name. I
am having problems figuring this out. I am sorta new to Access
and I only have a very basic understanding of the software. If
someone could please help me I would greatly appreciate it.

Enter this into the criterion row of the name column in the query
grid:

[Enter Name]

Run the query and you will be prompted to enter the name.

 

[John W. Vinson]

Were you able to find the old post?

You're being extraordinarily rude, and Bob is being extremely patient. Bob
(like the rest of us) is an unpaid volunteer donating his time. Telling him to
go do a Google search for a previous thread, and not even giving the subject
line of the thread, is a real imposition.

Perhaps we should take up a collection to refund your cost for getting this
free help.

 

[Bob Barrows]

You're being extraordinarily rude, and Bob is being extremely
patient. Bob (like the rest of us) is an unpaid volunteer donating
his time. Telling him to go do a Google search for a previous thread,
and not even giving the subject line of the thread, is a real
imposition.

Not that I totally disagree with the sentiment, I do have to say that he
did give the subject line of the previous thread ... very unhelpful
subject line (Access Query) but I was able to use it to find the thread.
Let's see if my reply in that thread helps him.