Need a quick way to update 2

[melaniews]

I know this should be simple but It's just not coming to me. I've added a date field to my table and I need to populate all 7000+ records with a date. They will all have the same date for this initial setup. Any suggestions would be helpful.
TIA
Melanie

 

[jebry]

Hi Melanie!

Try the following SQL:

UPDATE YourTable SET YourTable.YourField = #YourDate#;


hth
Jeff Bridgham
bridgham@purdue.edu

 

[melaniews]

Thank you, thank you, thank you. It worked beautifully.

Melanie