simple access 2000 query help 1

[phlash]

I am very new to databases and have a question if anyone would be willing to help. I have a simple access database (first, last, address, zip, and christmas list) I need to setup a query to pull everyone who has a check mark on christmas list in alpha order. Can anyone point me in the right direction please?
Thanks in advance.

 

[jrbarnett]

Go to new query and SQL view

Select first, last, address, zip
from table
where [christmas list] = true
order by last, first.

This brings in the fields against the select line
from the table called "table" (you will need to change this)
where the christmas list field is set to true, and sort those results by lastname and firstname within lastname.

John

 

[phlash]

Thank You John! You saved me alot research for something so simple =)

 

[jrbarnett]

Don't worry. When I was learning SQL I was looking at wizard generated code and tying this to what was in the SQL view and wondered what the heck it meant, then suddenly it clicked and thought "Why did nobody actually say that to me it would have saved lots of time."

John