Please help with this code

[eieiohh]

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

[fredg]

On 5 Oct 2005 15:23:55 -0700, ei*****@hotmail.com wrote:

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

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