Convert date for update query

[Joseph W Coffman]

I have a query that I want to use to update a table from another table. I
need to move the date to the new table (due to a redesign of the database),
but when I test the query I get blank fields. The date in table1 is not
formatted as a date, but as text. I have used the cdate([date paid])
function to do the conversion with no luck to this point. What am I doing
wrong?

The essence of the update is update "datepaid" in "Inventory" from [date
paid] in "commissions" and I am attempting to do this with the CDate or
DateValue functions, neither of which works in the preview mode.

We are running Access 2002

Any suggestions welcomed!

 

[Joseph W Coffman]

It runs flawlessly, and the number of records matches those that I did for
the parameters of the records to select. I guess it is working, because I
didn't get any errors?

You won't see the actual data value to which the fields will be updated when
you "test" the query in the preview (datasheet) view. You'll just see how
many records will be affected, and the current values of those fields (if
any values are there).

Does the query work correctly when you actually run it? Be sure to test on a
copy of the table first.

--
Ken Snell
<MS ACCESS MVP>

I have a query that I want to use to update a table from another table. I
need to move the date to the new table (due to a redesign of the database),
but when I test the query I get blank fields. The date in table1 is not
formatted as a date, but as text. I have used the cdate([date paid])
function to do the conversion with no luck to this point. What am I doing
wrong?

The essence of the update is update "datepaid" in "Inventory" from [date
paid] in "commissions" and I am attempting to do this with the CDate or
DateValue functions, neither of which works in the preview mode.

We are running Access 2002

Any suggestions welcomed!

 

[Ken Snell]

That's how I would interpret your results.

Good luck.

--
Ken Snell
<MS ACCESS MVP>

It runs flawlessly, and the number of records matches those that I did for
the parameters of the records to select. I guess it is working, because I
didn't get any errors?

You won't see the actual data value to which the fields will be updated when
you "test" the query in the preview (datasheet) view. You'll just see how
many records will be affected, and the current values of those fields (if
any values are there).

Does the query work correctly when you actually run it? Be sure to test

on

a
copy of the table first.

table.

I

need to move the date to the new table (due to a redesign of the database),
but when I test the query I get blank fields. The date in table1 is not
formatted as a date, but as text. I have used the cdate([date paid])
function to do the conversion with no luck to this point. What am I doing
wrong?

The essence of the update is update "datepaid" in "Inventory" from [date
paid] in "commissions" and I am attempting to do this with the CDate or
DateValue functions, neither of which works in the preview mode.

We are running Access 2002

Any suggestions welcomed!