adding specific date in a query field

[Ammodog]

I am trying to add a specific date to a query i have built. All I want it to do is propigate to all of the records. I have tried =9/20/2005 in build function but i get a wrong return, i have even set my format to date. Any answers out there? Thanks

Christopher Abney
There is no limit to the good you can do if you dont care who gets the credit

 

[RoyVidar]

If #9/20/2005# doesn't do the trick -> more infomation...

Roy-Vidar

 

[SkipVought]

Hi,

#9/20/2005#

dates are NOT strings -- they are NUMBERS.

Skip,
[sub]
[red]Be advised:[/red]We know Newton's 3 Laws. But did you hear about the [red]FOURTH???[/red]
Only ONE fig per cookie![/sub]

 

[Ammodog]

OMG, Thanks you guys! It has been a long time since I have worked with access. Trying to reeducate myself.

Christopher Abney
There is no limit to the good you can do if you dont care who gets the credit