Search results

I have written a very basic database which is held centrally and can be accessed by a group of colleagues. Recently PCs have been replaced and later versions of Access have appeared. This has resulted in the dbase being "converted" and now will not work on the earlier versions. Is there any...

It gets more complicated... As you correctly say I have a persons table, a club table, a school table all self expllanatory, I think. I also have a table which TRIES to link coaching agegroups at both school and clublevel. This table will have: cid from person table organisation eg sabc =...

Thanks It works

Is there any way I can stop the same permutation of three field values being duplicated in a table. eg a - b - c is ok a - b - d is ok b - c - e is ok a - e - c is ok a - b - c ......duplicate

Thanks for that Joe. At the moment my link table has 3 fields. a clubid;a list of Unumbers;and a person id. Are you suggesting that I should create a separate record for each unumber? This would mean, in some cases, having 6 records with the same clubid and person id. I had this and changed...

I have a table which has several separated values in a field. e.g >> u10 u11 u12 If I use one of these value as a criteria in a select query I can list all the records where a particular value eg u12 appears. There is also a need to produce a list of all the values grouped by u number. I...