Databases
John146
Posts: 12,926
Forum Member
✭✭
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
Probably a simple question, but I cannot find an answer
0
Comments
In SQL that would be achieved by adding a WHERE clause. I'm not familiar with how Access queries work.
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