Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
query

ResolvedVersion 2003

Barry has attended:
Access Introduction course

Query

What is a perameter query

RE: Query

Hi Barry,

Thank you for your question.

A Parameter query is created to provide a User Input box to enter the criteria you are looking for.

If you create a query and instead of writing the criteria directly underneath the field heading, you type a prompt in a set of square brackets. When you run the query an Input box appears asking you to enter the criteria.

E.g. Under the County heading:

[Please enter the County you are looking for?]


I hope ths answers your question.

Regards

Simon

Mon 30 Mar 2009: Automatically marked as resolved.

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.