Re: I want to check a field of table is "Null" or "Empty" in Acces

From: Anesh (Anesh_at_discussions.microsoft.com)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 01:27:01 -0800

 Steve,
         yes the table contain multiple records, and what i meant bu Null or
empty means that the field does not have any value. As sometimes these
records are deleted when some processing related to it is carried out. So i
hope this info could help you give a solution to my problem.

Best regards
Anesh

"Steve Schapel" wrote:

> Anesh,
>
> Can you please clarify a couple of things? Does the table contain more
> than one record? If it only contains one record, then you know at least
> which record to check for the existence of an entry in the Agency field.
> If there are more than one record, then you will need to identify
> which record to check, normally via reference somehow to the value of
> the priomary key field. In either case, you will need to use the
> DLookup finction, or another of the domain aggregate functions, to check
> the entry in the field. Secondly, what is the meaning of "Null" or
> "Empty"? Do you mean that the field may actually have an entry with the
> word "Null" or the word "Empty", as you question tends to suggest? Or
> do you mean that there is nothing at all entered in that field in the
> table? Do you mean thet Empty means the same as Null, i.e. that there
> is nothing there? Or are you indicating that there could be a
> zero-length string "" in there (this in practice is very unusual, unless
> you want it to happen for some obscure reason)?
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> Anesh wrote:
> > hi,
> > I want to check an agency name from the Agency field in the table is
> > "Null" or "Empty" in Access'03. So i want to create a macro with a condition
> > that checks or "Null" or "Empty", and if the cond is false then to Output
> > the report corresponding to the Agency name to an xls file.
> >
> > for eg : Agency name = POLI
> > Report name = repPOLIFax
> >
> > Thanks in advacne
> > Best Regards
> > Anesh
>

Relevant Pages