Simple query: Searching for surnames...

[GingerScouser]

Hi all,

Got a problem. I have a Database to complete for my I.T. project, and I'm running out of time with a crap load of stuff left to do.

I'm not a newbie to access, though I feel like it. I haven't used it for 2 years, since I was in High School, and I've kinda forgot how to do some stuff in it.

I need a query that will search for surnames. At present, I have 7 tables. Nothing is linked as of yet, no relationships. The tables contain simple data, such as forname, surname, dob, address, telephone number, etc.

What i want to do, is create a query that will allow me to type in any certain surname, and it'll then search through the tables to display any matches. I'm using Access XP.


I can't believe i forgot how to do all this stuff, that's why i'm asking you guys for help.

Thanks!

 

[dcx693]

You can to search through all the tables and fields for a potential match?

 

[GingerScouser]

You can to search through all the tables and fields for a potential match?

Yep, exactly that.

 

[dcx693]

The solution would involve some VBA code. You'd get a good grade for having the search work, but a bad grade for design!

How do you want to view the found records?

 

[GingerScouser]

The solution would involve some VBA code. You'd get a good grade for having the search work, but a bad grade for design!

How do you want to view the found records?

I want the little search box to pop up, and then for example when i type in SMITH, and it shows me a table of all the records that have that surname in it, showing me their details, such as home address and telephone numbers, etc.