Avatar billede logiq Nybegynder
05. november 2001 - 18:35 Der er 14 kommentarer og
1 løsning

SQL forspørgelse i access

jeg skal lave en SQL-forspørgelsel der gør jeg får en indtastnings box frem. eks. where \'kundetitel\' =[indtast kundetittel her] ..denne del fungerer,men nu kommer det der driller..boxen skal kunne finde frem til alt med f.eks assistent dvs overass.,underass., assistentmedhjælper osv. dette kan jeg ikke få den til. Er der nogen der har et godt fif til dette..tak for hjælpen!NB!jeg kan evt.maile databasen.
Avatar billede terry Ekspert
05. november 2001 - 18:36 #1
dktebrsa@europe.lego.com
05. november 2001 - 19:01 #2
Where [Kundetitel] Like \"*\" & [indtast kundetittel her] & \"*\"
Avatar billede terry Ekspert
10. november 2001 - 10:43 #3
logiq>Hope you could use the answer, remember what I said about Thomas\'s answer :o)
11. november 2001 - 17:20 #4
eh?
Avatar billede terry Ekspert
11. november 2001 - 18:15 #5
Hi Thomas! logoq sent me the db which  I have returned. The solution was very similar to what you had suggested, so I said they should share the points. But I think logiq has forgot to accept the answer. Thats all Thomas, not talking behind your back or anything like that :o)
11. november 2001 - 18:20 #6
Thnx Terry :o)

Didn\'t think so either!

But you just keep the points - the answered before me.
Besides - I have decided to stop competing with you. I will still give answers from time to time (it should\'nt be too easy for you to reach me :O)
Avatar billede terry Ekspert
11. november 2001 - 19:38 #7
Are you competing with me Thomas? if I had known that I would have taken even more of the questions and not given you a chance :o)
11. november 2001 - 22:43 #8
Well, you are right: you can hardly call it a competition, when I have almost twise as many points as you ;o)

But as you may already have noticed, I have stopped answering all the \'easy\' questions, to give you a chance. 
And the hard ones, you can\'t answer anyway, hehe :o)
Avatar billede terry Ekspert
12. november 2001 - 08:10 #9
Well concerning twice as many points Thomas, when I started you had about 9000 times as many points as me, and now its only two, so I can live with that :o)
I\'m glad you will take the hard ones though Thomas, how else would I learn?

12. november 2001 - 08:41 #10
I hope you are not in the finansial sector, considering the way you are calculating ;o)

9000/0=9000?
Or did you start calculating when you answered your first (30p) question:
9000/30=9000?

Anyway, we could be doing this all week ;o)
Avatar billede terry Ekspert
12. november 2001 - 09:03 #11
I agree Thomas, and we dont have time :o)
Avatar billede terry Ekspert
19. november 2001 - 20:41 #12
Hey! You got your answer two weeks ago, any chance of me getting my points?
Avatar billede terry Ekspert
22. november 2001 - 20:20 #13
Well you cant expect further answers, Jonas Andreasen [Jonas@Andreasen.com]
Avatar billede logiq Nybegynder
22. november 2001 - 21:31 #14
Sorry about the delay...
My name is Ulrich and it\'s my girlfriend Janni, who used my account for a school-project. As I have been busy (I have my own firm), I had no idea that I had points out on experten.dk...

Well, I hope that there are no bad feelings, cause I would like to continue using this site for future problems as well.

P.S. Janni has promised me to make her own account! ;o)
Avatar billede terry Ekspert
23. november 2001 - 08:11 #15
No problem Ulrich!
Yes I knew it was Janni who had placed the question, but I didnt know who was behind the name \"logiq\", thought it was Janni!
I assume Jonas is working on the same projoct...
It would be a good idea if Janni has her own account though.
Thank her for the points, and have a good weekend :o)
Terry
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester