If X then INSERT INTO Y 1

[sucoyant]

I'm having a bit of a problem with a query in Microsoft Access.

I need to pull data from the field 'todaysDate' that matches todays date. Then I need to place todays date into a field called 'dateSent'.

Any ideas?

----------------------------------------
Buddha. Dharma. Sangha.

 

[nagornyi]

Sounds like you can just put the current date into the datesent field.

 

[Golom]

This is only a template since I don't know what your fields are but try

   UPDATE tbl SET dateSent = Date{}
   WHERE  todaysDate = Date()

 

[sucoyant]

Golom: Thanks! Exactly what I needed.

I noticed though that you have Date{}, and Date().
Date() will work for both.

----------------------------------------
Buddha. Dharma. Sangha.