Using a parameter box to retrieve only one record.

[aarcorcar]

I am trying to create a Cutting Tool Lookup Screen that prompts the user For
first the Tool Name and then the number of tools desired. This second prompt
would be multiplied by three other columns in the Data base. I have the
database finished the the appropriate columns in place....maybe about 5
columns. I am really just looking for a simple tool lookup prompt followed
by a # of tools prompt followed by one result with my remaining columns being
displayed. These remaining columns have numeric values. Please advise! I
am new to Access.

Aaron Z

 

[OfficeDev18 via AccessMonster.com]

Aaron,

Welcome to Access!

You can do this directly in a new query, without a form. Copy and paste the
following into the SQL window of a new query. Just be sure you substitute
real table and field names for my fake ones.

SELECT ToolName, [Enter Qty] * fldField1 AS QtyField1, [Enter Qty] *
fldField2 AS QtyField2 (, etc. etc.) FROM tblYourTableName WHERE ToolName =
[Enter Tool Name];

Hope this helps,

Sam

 

[aarcorcar]

Thanks a million! That is just what i wanted. Have a great day.
Aaron Z