meaning of criteria
-
- BronzeLounger
- Posts: 1389
- Joined: 08 Jul 2016, 18:53
meaning of criteria
I have a In (47,49) in one of my queries. The query works with no problems but what does ln mean in access terms?
-
- NewLounger
- Posts: 14
- Joined: 27 Sep 2022, 07:22
- Location: Schiedam, NL
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: meaning of criteria
The query will return all records for which the field that has the In (47,49) criteria is equal to either 47 or 49.
It is equivalent to writing
47 Or 49
in the Criteria line, but it is shorter, especially if you want to specify more values.
It is equivalent to writing
47 Or 49
in the Criteria line, but it is shorter, especially if you want to specify more values.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1389
- Joined: 08 Jul 2016, 18:53
Re: meaning of criteria
Ok, thanks.