Re: First day of the year
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Thu, 14 Feb 2008 11:09:49 -0600
Glint wrote:
Thanks Rick,
Your advice is very incissive. I notice too that when I use IsNull in
a query builder criteria cell, it immediately changes it to IS NULL.
What should I do when the code is in the module in order to take
advantage of your advice?
If you mean when you are build SQL Statement strings in code the same thing
applies. If you mean something else you will have to clarify. The sql
clause "Is Null" does not work in VBA, but if you are creating SQL strings
then those are evaluated by the Jet query engine, not VBA.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- References:
- Re: First day of the year
- From: Rick Brandt
- Re: First day of the year
- Prev by Date: Re: Filtering Records in a Quary based on Duplicate fileds
- Next by Date: Re: Filtering Records in a Quary based on Duplicate fileds
- Previous by thread: Re: First day of the year
- Next by thread: RE: Queries
- Index(es):
Relevant Pages
|
