query

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Query

Query

resolvedResolved · Medium Priority · Version 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:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Server loaded in 0.08 secs.