#Error

#1 November 15th, 2004, 11:54 AM

Hi,

I have a query that combines several other queries with Left joins.

The 'main' query has a field called LDZ, this relates to the other queries
and forms the Join.

I run the query, but one of the fields shows #Error. This is because there
is no relative LDZ within the query.

Is there anyway of overcoming this rather annoying error?

Thanx in advance,
Steve

#2 November 16th, 2004, 02:13 PM

Sometimes the Nz() function can help.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

"FBxiii" wrote in message
...
Hi,

I have a query that combines several other queries with Left joins.

The 'main' query has a field called LDZ, this relates to the other queries
and forms the Join.

I run the query, but one of the fields shows #Error. This is because
there
is no relative LDZ within the query.

Is there anyway of overcoming this rather annoying error?

Thanx in advance,
Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Strange error messages in reinstalled Office	Hans Näslund	General Discussions	2	September 22nd, 2004 08:32 PM
Error message different in MDB and MDE	david epsom dot com dot au	General Discussion	1	September 21st, 2004 12:47 AM
Error Message different in MDB and MDE	david epsom dot com dot au	General Discussion	10	September 15th, 2004 12:30 AM
Help, i'm gettiing error: Access has encountered a problem and needs to close...	betsy	General Discussion	0	September 14th, 2004 08:20 PM
Continual Error 1321 Trying to Install Office 2003	Chad Harris	General Discussions	9	June 11th, 2004 08:19 AM