access courses - Select query

The UK's most regular instructor-led training courses.
Training information: access courses · Microsoft.access.courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Select query

Maureen has attended:
Access Introduction course

by - delegate Maureen [2 posts] (2007 Jul 23 Mon, 16:08) Reply

We have been into system selected query, typed in headings
selected field we required information from. Which was dates from and to, Selected view item and nothing happend.
Help what are we doing wrong?????
Rgds
Maureen Clarkson

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	2	book now	£235	£240
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Select query

by - trainer Richard platinum contributer [785 posts] (2007 Jul 30 Mon, 12:11) Reply

Hi Maureen

Create a new query using the following steps:

1. Click on Query tab on the left of the database window
2. Create new query using design view
3. Select the table you want the data from, click SHOW / ADD
4. Double click the fields you want to see showing in your query result.
5. View your query by using the view icon at the top left of the screen
6. Go back to the design view, using the same button
7. Add any criteria you want to filter by.

Does that help?

Regards

Richard

· Access VBA Handling Errors and Debugging Code
· Innovation with Microsoft Access
· Reasons to Consider Microsoft Access Training
· Microsoft Access Mistakes to Avoid
· Microsoft Access 2007: New Features

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