Search results

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...

Hi there currently i have a table which has the fields Member Age Group Disciplin r_time r_distance r_note date competition venue what i would like is for a report to be generated that analyses the table and pulls out the top 5 performances for each age group in each discipline stating the 5...

I have a large athletic club record database, all the information is in the database already however im having issues with one field. The field has to contain both distances in metres and centimetres AND times in hours minutes seconds and hundredths what would be an appropriate format for such...