Recent content by simbamfalme

never mind...i know its really weird but anyway thanks for the help. the query you gave me really helped me alot. thanks :)

there will be 18 results, but i need to count those and place them in the runner table

i dont exactly understand what ur asking. umm from what i understood this is my response: There will be 18 results of steve in the results table

i fully agree that the data shouldnt be stored. however, i am working on an already created database...one that was created by the previous designer, and it has the 2 fields noofruns and besttime in the runner table. also, there is a set of data in .txt format i have been given (previous older...

thanks for the help guys but i am limited to running the process without adding any new fields or tables...i know this may sound weird and i knwo it is. ANyway thanks for helping. more solutions are always welcome

i have a field for the run location. however, a requirement is that the runId must contain the first 3 letters from the location, followed by a sequential number. as it is i have a text file containing older data that followed this system, and need to create a newer system to add more records...

is there a way of doing it from the method i sstated above...using left() and DMax() functions. wat about using instr()????

Hi Guys. I am preparing a database that stores the records of runners such as their results, the runs they take part in, the locations where the runs take part, etc. One of the requirements is to have a the RunID as the first 3 letters of the LocationName, and then a sequential number which is...

Also, assuming that i have to store the data in the table...there are a few conditions i needed. The database has a run form, where details of every form are seen, and the users can add the runners and their times (i.e the results) through a results subform. i need the noofruns field to be...

one more question...why is it very bad to have such fields in your table..is it unreliable? or does it make the database very slow?

Ok wow..the query you gave me was very simple and seemed to do the work. However, i have a problem, in that i need the noofruns and the best results of each runner to be saved somewhere on the database...in such a scenario, what do you suggest i do. btw thanks for the immediate help.

Hi guys. Im pretty new to using access and am creating a database to store records of the runners and the runs they take part in. I have five tables, three of which are important for this question i have: Runner -RunnerID (Primary Key) -RunnerName -NoOfRuns -DOB -BestTime Runs -RunID (primary...