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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Parameters

Resolved · Medium Priority · Version 2010

Reply Wed 27 Jul 2011, 16:41Delegate Jassen said...

Jassen has attended:
Access Intermediate course

Parameters

How do you create a field that prompts a user to enter an import for a query using a wildcard?

For upcoming training course dates see: Pricing & availability

Reply Fri 29 Jul 2011, 12:28Trainer Anthony said...

RE: Parameters

Hi Jassen, thanks for your query. What you need is called a Parameter Query. There's a useful walkthrough right here:

http://www.techonthenet.com/access/queries/parameter3.php

Hope this helps,

Anthony

Thu 4 Aug 2011: Automatically marked as resolved.

Access articles

· Want to Become the Office Hero? MS Project Training Could be the Answer
· Create A Simple Form In Access
· Sub-reports And Sub-forms In Access 2007
· The Importance Of Backing Up In Access
· Discover How To Link An Excel Spreadsheet To An Access Database

Please browse our web site to find out more about
access.course and other Microsoft training courses.

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy