DS Forums



Thread Tools Search this Thread
Old 03-10-2013, 14:23
Forum Member
Join Date: May 2008
Location: Lancashire
Posts: 8,690

I keep a small database in Access of people I need to contact which I do via mail merging using letters/labels formatted in Word, but, sometimes I do not need to contact everyone in the database, is there any way I can select whose names/addresses I use on letters/labels?
Probably a simple question, but I cannot find an answer
John146 is offline   Reply With Quote
Please sign in or register to remove this advertisement.
Old 03-10-2013, 15:11
Forum Member
Join Date: Jan 2005
Location: Newbury
Posts: 6,902
Is there a common condition you can apply to those you want to include, that would exclude the others?

In SQL that would be achieved by adding a WHERE clause. I'm not familiar with how Access queries work.
JeffG1 is offline   Reply With Quote
Old 03-10-2013, 15:48
Forum Member
Join Date: Jul 2009
Location: UK
Posts: 17,870
access queries ARE Sql queries

Access just provides a nice visual interface to write/design SQL queries. for any access query, you can choose to see the SQL access designed instead of the visual representation

but your table needs an added field, say a yes/no field you can use to select the rows you want

then you can have a query that selects

select * from namestable where selectionfield = true
gemma-the-husky is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

All times are GMT. The time now is 04:48.