User Profile

Collapse

Profile Sidebar

Collapse
rodfuentes
rodfuentes
Last Activity: Mar 3 '14, 07:35 PM
Joined: Nov 1 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rodfuentes
    replied to Joining two fields with different lengths in data
    in Access
    Thank you all for your responses, I understand the flaw in the database design but since it's tables built by the company itself I don't have access to edit the layout on them.

    I'm still looking forward to create an optimized type of queue report with those fields included.

    Any ideas are welcome.
    See more | Go to post

      Leave a comment:

    • rodfuentes
      replied to Joining two fields with different lengths in data
      in Access
      I've tried so far to create isolated queries to match the fields based on calculated fields created on each one of those isolated queries, the best response time I've had is about 4 minutes 50 seconds.
      See more | Go to post

        Leave a comment:

      • rodfuentes
        replied to Join expression not supported
        in Access
        Thank you for your answer.
        I had lost track of that thread (I apologize I'm very new at this).
        It is not different at all, the result I'm trying to achieve is the same.
        However the tables were created a long time ago and therefore I don't think they considerated communicating these 2 tables together even though they share crucial data.

        Now, I have tried creating queries with calculated fields as you suggested but the...
        See more | Go to post

          Leave a comment:

        • rodfuentes
          started a topic Join expression not supported
          in Access

          Join expression not supported

          I'm trying to do a left join on two fields which don't have the same amount of characters.

          I'm using the following:

          Code:
          SELECT TABLE1.BKGNBR, TABLE2.DOCNBR
FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.BKGNBR = LEFT(TABLE2.DOCNBR,9);
          When doing this I'm getting JOIN expression not supported.

          I really need to take all records on TABLE1 and only the records in TABLE2 taking the first 9...
          See more | Go to post
          • rodfuentes
            replied to Joining two fields with different lengths in data
            in Access
            Thank you zmbd however this is the enterprise database, I cannot modify the tables therefore need to find a way around it to make it work
            See more | Go to post

              Leave a comment:

            • rodfuentes
              started a topic Joining two fields with different lengths in data
              in Access

              Joining two fields with different lengths in data

              Hello,
              I currently have two linked tables in my DB2 Database:

              Table1: Reservations
              Fields:
              Reservation_Num ber (ABC123456)
              Status

              Table2: Docs
              Doc Number:
              Reservation_Num ber (ABC123456000)

              I'm trying to match Reservation Number in both tables but table 2 has added three zeros at the very end therefore brings back no matches.

              I've tried converting...
              See more | Go to post
              • rodfuentes
                replied to hiding field in form if null and give msgbox if not null
                in Access
                Run-time error '2424':

                "The expression you entered has a field, control, or property name that toolbox can't find"

                And when I click on Debug, line # 5 is highlighted.
                See more | Go to post

                  Leave a comment:

                • rodfuentes
                  started a topic hiding field in form if null and give msgbox if not null
                  in Access

                  hiding field in form if null and give msgbox if not null

                  Good day,
                  I have a form (CSearch) to input data and search for records in a query and displays it on a subform (CAff) once a search button is clicked.

                  I have a current event on the subform that check if the field "CONTRACTSTATUS " is "Expired" and if so gives a message box saying "This contract is expired"

                  This works when the main form has been loaded already, but whenever I re-open the...
                  See more | Go to post
                  Last edited by NeoPa; Nov 1 '13, 03:53 PM. Reason: Please use the [CODE] tags when posting code.
                  No activity results to display
                  Show More
                  Working...