Newbie - help

[jamiepryer]

Hi All,
great forum here, loads of help and really busy

im very new to acces and have never used it before, however i have been using excel and VB for a while.

Ive been given a large table with about 5 fields in it and 40k + lines of data (!)

I need to write some kind of program/query, where i can input some txt and it will then lookup all the data that relates to that input txt.

Eg.
Car Tom Red
Car Tom Blue
Bus Dave Red
Bike Tom Pink

If i did a seach on "Tom" it would then give me the 1st, 2nd and 4th lines (all the info in that whole line)

If i did a search on "Red" it would give me the 1st and 3rd lines?

Im sure this is very simple, so any help would be great

Also, really sorry if this is in the wrong location, please move if so!

 

[Phonik]

Are each of the seperate words in seperate fields?

i.e. Field 1 Vehicle Type = Car Field 2 Owner = Tom Field 3 Colour = Red

 

[jamiepryer]

Hey,
yes they are

 

[jamiepryer]

i assume i need to use some kind of dlookup with an input box? but no idea how?

 

[neileg]

You need a parameter query. Look in Access help and come back if you're stuck.

 

[jamiepryer]

fantastic - thanks a lot mate, just what i was after! your a star