Re: One field ONLY...?

Kenneth wrote: 
Howdy,

We have a table with addresses. One individual might have
multiple addresses.

We have a field to assign certain characteristics to a
particular address, for example, send brochures to address
"A", or invoices to address "B".

For certain characteristics, it is important that only one
of the addresses be so marked. For example, we might want to
send invoices to one, and only one address.

u dont want to send 2 invoices to the same person at 2 different addresses? If yes try with sql "select DISTINCT contact from "addresses" where your_field='B'"
bye
marco
.

Relevant Pages

  • RE: [PHP] How to Execute Multiple SQL Updates Using PHP
    ... [PHP] How to Execute Multiple SQL Updates Using PHP ... values) are being placed in the SQL query. ...
    (php.general)
  • Is SQL a good language for this problem ?
    ... not known in advance and the values for each key can be multiple. ... The problem I have is that I can't find a way of doing this in SQL that's ... PRIMARY KEY, ... My best guess as of now (for what that's worth, which may not be much) is ...
    (comp.databases)
  • Re: Processing queries simultaneously
    ... Any way SQL Server will use multiple CPU's on ... CPU you probably have a bottle neck in one of two paces or both. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Filegroup recommendation
    ... >>> filegroup, and the transaction logs into their own filegroup. ... >>> and multiple hard drives. ... In a multiple-processor system, SQL Server ...
    (microsoft.public.sqlserver.server)
  • RE: Multiple-select from list
    ... If you are talking about putting multiple s in the list box item (1 ... of the List Box control to put together a where condition for your SQL ... Dim strWhere as String ... I want to be able to make multiple selections on my form from the same field ...
    (microsoft.public.access.forms)