Forspørgelse virker ikke hvis feltet er notat

Do yoiu use Access 97 at home?

det lukter lidt af st du skal have det uniform encoded, da jeg lige kaster et hurtigt gæt på at det er html tekst du gerne vil have i feltet.

prøv at studere urlencode eller hvis det er serverside at kigge på server encode

terry>> bruger samme version begge steder

seider>> det er html der skal gemmes i feltet, hvad mener du med urlencode ?

I have just read (Jet DATABASE Engine programmers Guide) that MEMO fields cant be used in UNION JOINS but you can convert to text.

Why it works at work but not at home I cant say.

EG:
SELECT table1.Memo1 FROM TABLE 1 UNION SELECT Tabel2.memo2 FROM table2 isnt allowed, but

SELECT LEFT(table1.Memo1,255) as m1 FROM TABLE 1 UNION SELECT LEFT(Table2.memo2,255 as m2 FROM table2 is.

det er også det der undre mig, måske er det en opsætning i Access!

prøver at kigge på din kode

I should have said, why it works at work at all I cant say.

The books says that MEMO fields CAN NOT be used in UNION JOINS. So its nothing to do with settings in Access, unless of course Access 2000 introduces something!

kan ikke helt få din kode rettet ind i min, er ingen haj til SQL, måske du kunne kigge på det ?
er villig til at smide flere point i
her er lidt kode:

SELECT tblCategory0.id, tblCategory0.id AS sort0, tblCategory0.sort01, tblCategory0.sort02, tblCategory0.sort03, tblCategory0.sort04, tblCategory0.sort05, tblCategory0.level, tblCategory0.name AS CatName, tblPages.nr, tblPages.name AS LinkName, tblPages.html, tblPages.target
FROM tblCategory0 LEFT JOIN tblpages ON tblCategory0.id = tblpages.id

UNION SELECT tblCategory01.id, tblCategory01.sort0, tblCategory01.id AS sort01, tblCategory01.sort02, tblCategory01.sort03, tblCategory01.sort04, tblCategory01.sort05, tblCategory01.level, tblCategory01.name AS CatName, tblPages.nr, tblPages.name AS LinkName, tblPages.html, tblPages.target
FROM tblCategory01 LEFT JOIN tblpages ON tblCategory01.id = tblpages.id

can you send the db to me?
dkTeBrSa@europe.lego.com

den er allerede sent :)

harlequin> I havent received anything yet, the hyperlink is lego.com

den er sendt nu, fik ikke .com med i din e-mail addresse

its on its way!
I have altered your query qlp to qryqlpTerry

I sent it to arintertrading.dk but got an error so I have now sent it to smartonweb, is that OK?

mange tak, ser ud til at det virker nu :)

smider 100 mere i

/harlequin

thats fine, thanks!