var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Hey this might be a rather simple question but i cant find the answer on the access tutorials n such....
My problem is:
I have a column of the names of people who own property, some own more than one... what i wanna do is delete all the repeated names and just leave one?
thanks for the help
Create a new (blank) table with a column or columns for the names you want to hold and write a SELECT DISTINCT(Name) INTO query. There should be plent of help for the SELECT INTO query. Then use the new table (rename it if necessary).
Under the query Tab there is a wizared will help you getting the repeated Items in any table
thank you both
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors