Microsoft Access

[touch]

I'm trying to make a report in access which needs to show information on 1 record only. The record wil be chosen by the user, preferably through a prompt window or something.

Any help appreciated (im a bit of a database noob )

 

[tonyyeb]

You need to base the report on a query. And that query will just pull record number x.

Here is a good place to start:

http://office.tizag.com/accessTutorial/accessqueries.php

Edit: Quick tip. To get user input in a query, edit the query and in the field which you want the search based on, enter something like [Enter Product] in the crtieria box. This will open an inout box title "Enter Product". Obvioulsy you choose something appropraite.