Access Request (research)

[Zoso26]

*I apologize for my bad english informatic terminology in advance*



I don't have Access on my present computer so I can't manually check, but this is eating me up.

When you make an Access ''request'' (in french: Requête, but I think in english it's ''query''), is the research bu default based on a simple word or on a non-defined chain?

Thanks guys :)

[CJ_London]

it is based on the SQL language - there are a number of dialects, but many words are the same.

There is a basic structure - for example for a simple query would be structured like this

SELECT these fields
FROM this table
WHERE this field equals a value
ORDER BY these fields

correct spelling is important!

There are many free resources on the web e.g.

http://www.w3schools.com/sql/