Microsoft Access Query Formulas Combining Fields, Arithmetic

[jessjames1911]

sooooo much more helpful than our 2 hour class on this.

[FiveBlackGuyz]

Why do I even go to university... I learn more on the internet.

[aspdotnetexperts1]

Thanks for sharing this informative Video. For Expert Level .NET Video's visit "TheSYNERGETICS" channel on youtube . Synergetics is Awarded as the Best. NET Training Service Provider by Microsoft

[YTcomic]

hi - I have an access 2007 database

So a table was created.

It contains, "Model" "Description "Direct" "Supplier" "Quantity" "Keywords".

I created a couple of queries. One is a search within the "Model" field.

The criteria I used is...

Like "*" & [Please type keyword to search] & "*"

I am about to create another query with the same criteria in the "Description" field.

How can I create a query that can search all 3 fields in a single table at once, without the need for having 3 separate queries?

[vt1875]

helped a lot! thx!

[thiaguwinid]

clear explanation with simple example. thanks a lot