Convert date for update query

  • Thread starter Thread starter Joseph W Coffman
  • Start date Start date
J

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!
 
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?

Ken Snell said:
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>

Joseph W Coffman said:
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!
Click to expand...
Click to expand...
 
That's how I would interpret your results. :-)

Good luck.

--
Ken Snell
<MS ACCESS MVP>

Joseph W Coffman said:
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?

Ken Snell said:
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
Click to expand...
on
a
copy of the table first.
Click to expand...
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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top