Query a must for Report

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

I am very confused, I am told I must create a query first
before I can do my report.

I have already created my report and what I want it to do
is ask the user what record they want printed - i.e.
record 86.

Currently the report prints out ALL records.

Can someone help?

Sorry I am very new to access and am still learning.

Thanks very much for any and all help.

Kind regards,

Ty
 
Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

Use these steps to create query that prompts for record number:

1- Open the report you created in design view.
2- Locate the report's Properties (Edit | Select Report, View | Properties).
3- Click on the Data tab and on the Record Source property click on the
Builder button on the right.
4- Click "Yes" you want to build a query.
5- When the query window opens, drag down each of the fields from the field
list box.
6- Locate the column in the query that has the field with the record
numbers.
7- On the Criteria line of that column type what you want displayed to the
user between square brackets. Something like:

[Enter The Number Of The Record]

8- Close the query window and save the changes. Save your changes to the
report.

Now when you open the report, you will see it prompt you for the record
number.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top