Re: is it that complex?

Article View: comp.databases.ms-access

Article #201

Back to comp.databases.ms-access Previous Next

#201

From: Sascha Wostmann
Date: Sun, 23 May 2004 22:36

43 lines
2522 bytes

asd987 :

> Hi,
> 
> I have a problem to print the correct data to a file.
> 
> I have two tables:
> 1. "names" with the records
> -  "id" (autonumber / primary key)
> - "description" (text)
> 
> 2. "things" with the records
> - "date" (date)
> - "object" (memo)
> - "name" (this refers isong lookup to table "names" the record "id")
> 
> 
> I do:
> 
> print #1, rstfile2!date
> print #1, rstfile2!object
> print #1, rstfile2!name
> 
> As expected I get a number on the third print-command. I tried several
> things to get the "description" of the "id" printed but didn't succeed.

if you don't want (or can) change the data source for the export, use:

  print #1, dlookup("description","names","id=" & rstfile2!name)

but this is quite slow on large exports, since each lookup has to be
done seperately.

BTW, don't use "name" as column name because it's used internally too.


Viele Gr��e,
Sascha Wostmann
-- 
wichtige Informationsquellen zu Access:      +----------------------
http://www.donkarl.com/    (FAQ)             | Bitte keine Kopien
http://www.freeaccess.de/  (KnowHow)         | oder Access-Anfragen
http://www.google.de/      (Suchmaschine)    | per E-Mail.

Technical Details

Message-ID: <2hcnc1Fb83omU4@uni-berlin.de>

Path: arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!not-for-mail

References: <c8q0k8$47o$1@news2.tilbu1.nb.home.nl>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: ff0ac,26e13a2853c27e7e
X-Google-Thread: 102b1d,26e13a2853c27e7e
X-Google-Thread: 11387c,26e13a2853c27e7e
X-Google-Thread: 111a5a,26e13a2853c27e7e
X-Google-Thread: 101bdd,26e13a2853c27e7e
X-Google-Thread: fe218,26e13a2853c27e7e
X-Google-Thread: 1128b1,26e13a2853c27e7e
X-Google-Thread: 113a89,26e13a2853c27e7e
X-Google-Attributes: gidff0ac,gid102b1d,gid11387c,gid111a5a,gid101bdd,gidfe218,gid1128b1,gid113a89,public
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: Sascha Wostmann <s.w@gmx.de>
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,dk.edb.database.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.office.access.forms,microsoft.public.office.access.formscoding
Subject: Re: is it that complex?
Date: Mon, 24 May 2004 00:36:47 +0200
Organization: privat
Lines: 43
Message-ID: <2hcnc1Fb83omU4@uni-berlin.de>
References: <c8q0k8$47o$1@news2.tilbu1.nb.home.nl>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: news.uni-berlin.de 8MRPL91g3KREj+IuvkFgjAliQO6X5FHi86tTOB5S+UMbwgrqo=
X-Newsreader: Forte Agent 1.93/32.576 English (American)

Reply to Parent Message