Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    London, Gtr London, England
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Make Table Format

    I am trying to create a table containing dates from a Make Table query. In the output table, I need the format to be dd:mm:yy hh:mm:ss. Do you know a way of enforcing this?

    Please help. Thanks.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make Table Format

    Would it work if you created the table structure with the date field in the format you wanted and then instead of using a create table query, use an append query to pull your data into the table you created?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

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