Merging two fields in one table

[Joye]

I have a form with a combo box for a lookup. Right now it is looking people up based on their Current Family name. I also have a field for maiden name and I want to combine both the current name and maiden names into one column (not concatenate) so people can look up by using either. I know how to use a Union query to do this with information from two different tables, but how do you do this with data from just one table. Any ideas????

 

[RichO]

Look in the Data tab of the properties box. Where it says Row Source, you'll probably see something like:

SELECT [MyTable].[FamilyName] FROM MyTable;

Add your maiden name field to the select:

SELECT [MyTable].[FamilyName], [MyTable].[MaidenName] FROM MyTable;

Then in the Format properties, you'll have to change Column Count to 2, add a duplicate column width for the second column (right now it should have just one width - so if you see 1", make it 1";1") and double the List Width so you can see the new field.

See if that works for you.

 

[joeselch]

Perhaps the attached will help...
one table of people
two queries - one last name, the other maiden name
one union query - pulling last and maiden names

However, this will get interesting when you have people with the same last and/or maiden names...