Search results

so do we have a solution to this problem

sorry i was asleep, i am sending you this databse in 97. i hope it will work now

I am sending you whole database and you can look it into. every time when you open database is the same result.

EMP this is great thank you

sorry I don't understand this completly,can you maybe give me some SQL statment for example thank you

I tried this Joe Foster code but i get each time when i start same results. am i doing something wrong or is this the same mistake like at the other one

ja this is right i knew it can't be that easy, but if you start this function twice you get new 300 records. ja this is bad solution but it is :(

hello i have this problem with my database i have data base with 195000 records,but when I try distinct function on number of company (ICO) i get 145000 records.so 50000 records have duplicats, this is not nice to work with it. so can anyone tell me how can I get just those 145000 records...

hello i found easy solution to this problem SELECT TOP 300 * FROM Tabela ORDER BY Rnd([ID_Zapis])

ok here it is but it is only in excel becouse of 100 k limit i hope you can help me, good man

thank's i saw that thread before but i realy can't figure out how to do this so it is easier to do it in VB than in query,you know i am complete zero in VB there is now way for me to do it. :mad:

:confused: Hello i am new in this word and i need help with random function. I have a tabel with 1500 records and i want to get 300 records out of it randomly. thank's for every help