in-line function in queries

[Guest]

I'm attempting this in a query [access 2003], but i get the error:
"unknown function in 'Date' in expression"

Could someone point me in the correct direction? TIA.

UPDATE quote SET quote.[Quote Status] = "Expired"
WHERE (((quote.[Quote Status])="Open") AND ((quote.QuoteExpires) < Date()));

 

[Roger Carlson]

Sounds like a problem with your References. See the following:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I'm attempting this in a query [access 2003], but i get the error:
"unknown function in 'Date' in expression"

Could someone point me in the correct direction? TIA.

UPDATE quote SET quote.[Quote Status] = "Expired"
WHERE (((quote.[Quote Status])="Open") AND ((quote.QuoteExpires) < Date()));

 

[Guest]

Thanks Very much once again RC. Problem fixed though query isnt working as i would like.

Any idea as to why that may be?

Thanks.

Sounds like a problem with your References. See the following:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I'm attempting this in a query [access 2003], but i get the error:
"unknown function in 'Date' in expression"

Could someone point me in the correct direction? TIA.

UPDATE quote SET quote.[Quote Status] = "Expired"
WHERE (((quote.[Quote Status])="Open") AND ((quote.QuoteExpires) < Date()));

 

[Guest]

Got it. I wasnt looking at what the colum was bound to. Thanks.

Sounds like a problem with your References. See the following:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I'm attempting this in a query [access 2003], but i get the error:
"unknown function in 'Date' in expression"

Could someone point me in the correct direction? TIA.

UPDATE quote SET quote.[Quote Status] = "Expired"
WHERE (((quote.[Quote Status])="Open") AND ((quote.QuoteExpires) < Date()));