Recent content by ninefoureight

Thanks Mike, certainly a nudge i needed. I think i was looking for a shortcut something like a new table was created for every users record. I'm not sure what you mean by "othwer questions"? I will in time use the User Table for further projects but for now im aiming just to keep it based on...

Hi there im just about to start a new database, but i cant decide within myself what would be the best table design. The database is going interface with my site where a user logs in, and can check off the Munros (hills over 3000ft in Scotland) as they do them and it retains it on their record...

thanks john i realised that almost the instant i posted, ive added the indexes now. My query takes roughly 30s to generate the results, not instant but its not a query i require to run regularly so the time is negligible. Thanks for everyones help, no doubt ill be back when i next likely get...

Thank you John thats exactly what i needed, made a mistake in my referencing to using another table but sorted that now. For the indexes do you make 3 seperate indexes ? Many thanks! :}

one possibility could be in some records the r_time field is empty as it is not appropriate could this cause the system hang ? when the r_time field is not populated the r_distance field is.. im at a total loss and cant seem to see the light for the data .. thanks

SELECT a.*, a.member, a.r_time FROM recordsorts AS a WHERE (Select Count(*) from recordsorts where AgeDis=a.AgeDis and r_time >= a.r_time) Between 1 And 5 ORDER BY a.AgeDis, a.r_time; ok i made a query to concatenates the three fields age group, sex and discipline in that order to produce the...

so by that you are suggesting i merge the agegroup and discipline fields yes i will also want to be seperating the males from females so i would then concatenate all 3 to produce the required results upon sorting? Can i do this in a query to produce a new table of top5 records for each age group...

i understand the top n values help but my problem is using it to to my double double query see for each age group there are 10-20 disciplines and i need to have the query/report return the top1-5 of each age group per discipline if that makes sense? ie i have 3 age groups u11 u13 u15 and 4...

Just resaved it didnt give me the explicit option of having it as a access97 format so i hope its right. thanks

sry here it is http://090480.net/_misc/clubrecords.zip

I have read the material you directed me to RE : selecting the top 5 however i am still at a loss at how to go about manipulating my own data to make the required querys and reports. Further to the example i have two instances which the query must select and choose the top 5. From the results...

hi rob where do i enter the expression ?

thanks rob for such a prompt answer, im currently searching and learning as i go. Cheers ;]

thanks Pat, ill have a play with that code in reference to my own database. Cheers!

hi, i have a database that i want people to be able to add to in an online enviroment however i want any records they add to be highlighted as unratified records. The way i was considering doing this was having a checkbox field for each record which is only editable by myself the administrator...