How to upade the table

[1994mkiv]

I have some old open orders in the database that I would like to close. The way the table is design the value is 0 if the order is open and -1 if the order is closed. I want to close all orders older than 1/1/2004. Can I update all records by using the query?

 

[maxhugen]

Sure, use an Update query, eg:

[tt]UPDATE myTable SET myField = -1
WHERE myDate <"#1/1/2004#";[/tt]

Just change the table and field names as appropriate.

Max Hugen
Australia

 

[1994mkiv]

I am sorry I am really new to the access. Where do you write the sql quires in access.

 

[SkipVought]

in the query tab, SQL view.

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]

 

[dhookom]

Actually the SQL view should remove the quotes around the date value like:

UPDATE myTable SET myField = -1
WHERE myDate <#1/1/2004#;

Duane
Hook'D on Access
MS Access MVP

 

[maxhugen]

Oops, thanks Duane :~/