Find all instances of item

P

PaB

I am new to Access and have had no training. Hopefully
someone will be willing to help me.
I have a table containing several item numbers and the
corresponding physical characteristics of those item
numbers. I need to be able to type in an item number and
have the program search and return all instances of that
item number along with the related physical
characteristics for each instance of that item number.
Will someone be willing to help me? Is this too complex a
question for this format?
Thank you.
 
G

Guest

hi,
sound like a simple select query.
in the database window
click the query tab.
click new query.
click ok
in the show table box, scroll down and double click the
table that has the data you want to see.
click close. the show table box will go away.
the table you double clicked in in the query pane.
scroll down an double click all the fields in the table
you want to see.
on the criteria line at the bottom of the query, type in
your item number.
on the tool bar, click query>run.
:)
 
P

PaB

Thank you, Les. That was exactly what I was looking for,
and very simple too.

-----Original Message-----
Are the item numbers and characteristics in the same
table? If so, create a new query, use the table as the
data source, select item number and characteristic fields
in the query design grid. In criteria for item number,
type something like the following, including the brackets:

[Enter Item Number]

When the query runs, it will prompt with "Enter Item
Number". When an item number is keyed in, all rows in the
table that match that item number, and its characteristics
will be returned.

Hope this helps.
-----Original Message-----
I am new to Access and have had no training. Hopefully
someone will be willing to help me.
I have a table containing several item numbers and the
corresponding physical characteristics of those item
numbers. I need to be able to type in an item number and
have the program search and return all instances of that
item number along with the related physical
characteristics for each instance of that item number.
Will someone be willing to help me? Is this too complex a
question for this format?
Thank you.
.
Click to expand...
.
Click to expand...
 
Top