Office 2000
I have a student table having the following fields. student_id, name, surname, amount
How do I write query to prompt me for the student_id in a report
Web Development
I have a student table having the following fields. student_id, name, surname, amount
How do I write query to prompt me for the student_id in a report
by sgt_shultz
this is cut and pasted from Access 2000 help:
-----------------------------------------
Create a select or crosstab query.
In query Design view, drag the fields from the field list to the query design grid.
In the Criteria cell for each field you want to use as a parameter, type a prompt enclosed in square brackets. Microsoft Access will display this prompt when the query is run. The text of the prompt must be different from the field name, although it can include the field name.par
For a field that displays dates, you can display the prompts "Type the beginning date:" and "Type the ending date:" to specify a range of values. In the field's Criteria cell, type Between [Type the beginning date:] And [Type the ending date:]
To view theresults, click the View button on the toolbar, and then type a value for the parameter. To return to query Design view, click the View button on the toolbar again
----------------------------------------
keep us posted on how it's going
This discussion is closed to new replies.
Sort by Trending