What does "Where" mean here?

[Guest]

Hi all,

In summary query, there is a where() function, could you give an example to
explain its use

Clara
thank you so much for your help

 

[Allen Browne]

Clara, create a query using any table you like.

Type something in the Criteria row under one of your fields.

Switch the query to SQL View (View menu.)

You will see that the query is made up of a sentence that reads like this:
SELECT ...
FROM ...
WHERE ...

Can you see how the WHERE clause of the sentence matches the criteria you
asked for?

 

[Guest]

Hi allen,

How can I use "Having" clause in Query Design Grid

Clara

thank you so much for your help

 

[Allen Browne]

Depress the Total button on the toolbar in query design.
Access adds a Total row to the grid.

Type your criteria in under one of the fields.
If you have Group By in the Total row, the criteria goes in the HAVING
clause. If you have Where in the Total row, Access puts the criteria in the
WHERE clause.