Query Based on an Input

[John Calder]

Hi

I run W2K and Access 2K

This is my 1st database. I have created a database that has the following
fields:

Date (formatted to date)
Time (formatted to time)
Crew (taken from another table)
Coil Number (formatted to text)
Edge Damage (formatted to memo box)
Bore Dents (formatted to memo box)
Comments (formatted to memo box)


What I would like is to create a report that I can type in a Coil Number and
all
the information associated for that coil number (including the coil number)
only is shown on the report.

I am assuming that the report would have to be based on a query. So can
anyone tell me how ro write the query to achive this?


Any help is much appreciated

John

 

[Duane Hookom]

There is at least one reply in the Reports news group where you asked
exactly the same question. You should limit your questions to a single news
group.