microsoft.public.access

You were right... The line had been split to two...

Now, here's the thing... I don't know where this module is supposed to go or
how exactly it works... Any sort of guidance or reference would be very much
appreciated.

Thanks!

"Dirk Goldgar" wrote:

> In news:B32E000C-3B10-40DE-A048-1EA5ACAB286E@microsoft.com,
> TechTutors wrote:
> > Thanks Mr. Nicholson...
> >
> > I had noticed that line prior to my post and made the changes just as
> > you suggested. Unfortunately, I still recieve the same error:
> >
> > Compile error:
> > Expected: list separator or )
> >
> > And those lines of code still remain red.
> >
> > "George Nicholson" wrote:
> >
> >> If your table is called tbl_Holidays then:
> >> DCount("*", "tbl_holidays", "[holdate] between #" & dtmStart & "#
> >> And #" & dtmEnd & "#")
>
> Just in case: are you entering these code statements all on one line?
> As they come through the newsreader, what were originally single lines
> of code are being broken into two lines. To write a statement over
> multiple lines requires the use of a continuation character.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>