On 5 Oct 2005 15:23:55 -0700,
eieiohh@hotmail.com wrote:
[color=blue]
> I'm pulling my hair our...
>
> Table Name=Excel
> Form = freports
>
> I am trying to run a Select statement from the Excel table where the
> datareceived date is between (and including ) the dates on my freports
> form... Can anyone tell me what I am missing here.
>
> ....." From Excel " & _
> "HAVING (((Excel.DataReceived)>=[forms]![freports]![from]&
> And([Excel.DataReceived)<=[forms]![freports]![thru])))"
>
> TIA[/color]
I suppose you mean you are running a query, using the Excel table as
data source.
You have an extra & that is not needed.
[forms]![freports]![from]&
Try
HAVING (((Excel.DataReceived)>=[forms]![freports]![from]
And([Excel.DataReceived)<=[forms]![freports]![thru])))
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
