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

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

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