Microsoft Access query name arrangement from the table

[successfulfail]

Hello, I'm just learning how to use Microsoft Access from the school.



My teacher says that I have to get "Last Names" from the "Club Members" table and get all the last names starts with the letter "D".

I know how to do this with using the "Filter" function. However teacher says that I must create a new query to do this.

I have no problem with getting Field to "Last Name" and Table to "Club Members" I just don't know how to sort the names out without using the "Filter" function on queries....

Please help!


Many thanks

[June7]

I don't understand. What do you mean by 'filter function' - the Filter property? Use criteria row in query designer to filter records. For your requirement, the SQL would be something like:

SELECT * FROM [Club Members] WHERE [Last Names] LIKE "D*";

[successfulfail]

I don't understand. What do you mean by 'filter function' - the Filter property? Use criteria row in query designer to filter records. For your requirement, the SQL would be something like:

SELECT * FROM [Club Members] WHERE [Last Names] LIKE "D*";

Sorry, what I mean by "Filter function" is just the filter feature you can see it on the Home menu...


So far from the Expression Builder I have got:

" [Club Members]![Last Name] "

How would I be able to show: Last Names that starts with the letter "D"?

[June7]

Why are you using Expression Builder?

I gave you an example query that will produce the output you describe. Use the Query designer. This is VERY basic Access functionality. You should review textbook or consult with instructor.