Results 1 to 27 of 27

Thread: Update query simple (beginner)

Threaded View

  1. May 29th, 2007, 11:49 AM #10
    gphillips
    gphillips is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2005
    Posts
    393

    Re: Update query simple (beginner)

    Hi thanks, I HAVE Chnaged the table names etc, its very confusing using des ref an des ref2 because the fields and table names are the same.Please Can you review using from last post, and also consider data and time and conversion if needed?? The data type from the end date is datetime.


    You seem to have removed bracket references of tables as well.Also why '20070525' will this affect the format below??

    In the visable table itself I need to update to just the date:

    In the below format

    30/05/2007


    I can't change the datatype as it will affect a lot of other tables.
    Last edited by gphillips; May 29th, 2007 at 01:36 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width