Re: Limiting Records with Null Only Once

From: Dan (anonymous_at_discussions.microsoft.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 03:33:45 -0700

Thanks for the reply.
If I can't say the count of field B being null is less
than 1 in a table, would I be able to say it and combine
it with field A is not null in an append query.

Thanks for you help.

Dan
>-----Original Message-----
>You can use the Validation Rule of the table to insist
that both fields
>cannot be Null together, but you cannot create engine-
level validation to
>insist on a count of nulls in a field.
>
>--
>Allen Browne - Microsoft MVP. Perth, Western Australia.
>Tips for Access users - http://allenbrowne.com/tips.html
>Reply to group, rather than allenbrowne at mvps dot org.
>
>"Dan" <anonymous@discussions.microsoft.com> wrote in
message
>news:ba1f01c48964$c61052f0$a501280a@phx.gbl...
>>
>> How would I go about limiting a record's existence in a
>> table by the following criteria. Field A is not null
and
>> field B is not null, or field A is not null and field B
>> is only null once.
>>
>> If this can't be done in a table, can it be written
into
>> an append query, as all of the new records are
>> automatically appended to the table?
>>
>> Your help is greatly appreciated.
>>
>> Dan
>
>
>.
>

Relevant Pages

  • Re: Limiting Records with Null Only Once
    ... The problem then occurs if your append query actually adds 2 or more records ... "Dan" wrote in message ... >>You can use the Validation Rule of the table to insist ...
    (microsoft.public.access.queries)
  • Re: Prevent Duplicate Values
    ... rather than allenbrowne at mvps dot org. ... I don't like the horribly technical message when the rule is ... The values in this field (Membership Number) are not ... > Is there a validation rule I can use instead? ...
    (microsoft.public.access.forms)
  • Re: Accessing multiple fields in report function
    ... Dan, you will need to pass all the fields from the record to your function. ... If the function is called CountTrue, and you need to pass 3 fields, you ... rather than allenbrowne at mvps dot org. ... > return a string containing the names of all of the boolean fields that are ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to specify default in SQL Create TABLE?
    ... That works and it does populate the Default field in Design View. ... How do you set the Validation Rule? ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Changing Seek with a Null to Findfirst Method
    ... Dan ... >If you are still stuck after my last reply (parallel to ... rather than allenbrowne at mvps dot org. ... >> clause of a SQL ...
    (microsoft.public.access.formscoding)
Loading