I want to check a field of table is "Null" or "Empty" in Access'03

[Guest]

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

 

[Steve Schapel]

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)?

 

[Ken Snell [MVP]]

Anesh -

It appears you've started a new thread on the same issue that we were
discussing in an earlier thread (just a few hours ago). I will assume that
you do not need me to continue that earlier thread.

 

[Guest]

i am sorry i am new to this discussion group, thats why i strated a new
discussion, its only now i know that you can continue on the same discusion,
so pls kindly help me out in this issuse as i am still unable to resolve the
problem.

 

[Guest]

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]

Anesh,

Thanks for the clarification. But we would still need to know how you
will know which record in the table you want to check for a Null in the
field.

Maybe it will help if you can give some more details with examples of
what you are trying to do.