User Profile

Collapse

Profile Sidebar

Collapse
Nabil Bugaighis
Nabil Bugaighis
Last Activity: May 6 '13, 08:49 PM
Joined: Sep 16 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Nabil Bugaighis
    replied to Update Query for Date
    in Access
    Excuse me for being thick :) I got it and it works like a charm. Much obliged.
    See more | Go to post

      Leave a comment:

    • Nabil Bugaighis
      replied to Update Query for Date
      in Access
      Hi, Thank you so much.
      Is there a way to make it in one query as I need to run this daily.
      I was hoping to have a shortcut to the query I can just run each day to fix the dates in the Tracking Table.
      See more | Go to post

        Leave a comment:

      • Nabil Bugaighis
        started a topic Update Query for Date
        in Access

        Update Query for Date

        Hi. I would appreciate help an Update Query for Microsoft Access 2003 to change the date format for some entries.

        Some of the dates are written to the table in this format:20130410 112143 , which is YYYYMMDDHHMMSS .
        The column name is PickupDate (data type=Text) , and the Table name is Tracking

        I need to change only the entries in this format to a YYYY-MM-DD format.
        Nothing else in the table should change....
        See more | Go to post
        • Nabil Bugaighis
          replied to Find and Replace query from a 2nd table.
          in Access
          Thank you for the suggestion.

          I tried this, but it does not work. This what I tried:

          UPDATE categories
          SET description=rep lace("descripti on",[redirects].[oldurl],[redirects].[newurl])

          I need it to go through the "redirects" table row by row, picking each [redirects].[oldurl], looking in the [Categories].[description] column, and replacing each instance of [redirects].[oldur...
          See more | Go to post

            Leave a comment:

          • Nabil Bugaighis
            replied to Find and Replace query from a 2nd table.
            in Access
            Pat,
            Thank you for the reply. But this would not work.
            The problem is that the field "descriptio n" has a lot of info in it with mulitple urls.
            In the example below there are TWO old urls, each would need to be found and replaced with the new-url1 and new-url2 from the "redirects" table.

            <table border="0" width="600" id="table1" cellspacing="0" height="156"><t r><td><img...
            See more | Go to post

              Leave a comment:

            • Nabil Bugaighis
              started a topic Find and Replace query from a 2nd table.
              in Access

              Find and Replace query from a 2nd table.

              Hi, I'd be grateful for any assistance.

              I am using Access 2003, but I also have Access 2007.

              I have a table (Categories) with a column "descriptio ns". This column has html code including several urls per field (1000 rows not all unique. some fields might be duplicated in several rows)

              I have a second table "redirects" with two columns, "Old-URL" and "New-URL" (600...
              See more | Go to post
              No activity results to display
              Show More
              Working...