Ok i follow you. so the problem i have now is I don't think its real clear how to make Dataassist search wizard search two columns and return the results i'm looking for, which is why i was askindg about inserting two fields into one. for example: I need to be able to do 2 things.
1 search a date like 10/12/2009 and get a list of all rows with that date.
2 add am/pm/nite to the serch and get just the rows with both the date and the am/pm or nite .
it sounds simple but this is one of those "can't find the how to section " on this.
I appreciate ur help
Dean