Date Parameter in Macro

[alectek]

Hi!
I'm using MS Access 2003.
I create the Macro to run bunch of queries. All of them have the same field [svs.date], and for all of them I want to set this field to the same value. Let's say [svs.date] >= #7/1/2006#. Any way, I can do it in a Macro.
Thank you very much for help.
Alec.


Thanks.
Alec.

 

[AlexCuse]

Are you trying to update everything in a table to have the same SVS.Date or update each query so that it uses the specific svs.date?

Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.

 

[SkipVought]

Hi,

You're not clear. Do you have a textbox with the date?

SQL = "Select .....
"From .....
"Where.....
"  and [svs.date] >=# " & DateTextbox.value & "#"

Skip,
[sub]
[red][/red]
[/sub]