Digital Spy

Search Digital Spy
 

DS Forums

 
 

Databases


Reply
Thread Tools Search this Thread
Old 03-10-2013, 14:23
John146
Forum Member
 
Join Date: May 2008
Location: Lancashire
Posts: 6,783

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
JeffG1
Forum Member
 
Join Date: Jan 2005
Location: Newbury
Posts: 4,840
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
gemma-the-husky
Forum Member
 
Join Date: Jul 2009
Location: UK
Posts: 12,842
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
 
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search

 
Forum Jump


All times are GMT +1. The time now is 03:20.