Results 1 to 4 of 4
  1. #1
    Grahamiwa is offline Novice
    Windows 98/ME Access 97
    Join Date
    May 2011
    Posts
    6

    Generating a text value based on two field values.

    My previous post on this question didn't seem to post.

    I have a recipe table that contains a product code as a text value. It also contains the recipe I'd number.
    I have a product log table.
    One of the entries in the product log table is the recipe id number.
    What I would like to happen is when I create a new log entry and enter the recipe id no in the log the product code is imported into the product log table.
    I have posted a question on how to do this.

    My question
    How can I automatically combine the product lot no and the product code to form a final product code?

    Example
    Lit No 300


    Product Code CU.WM.SS
    Final Product Code 300.CU.WM.SS

    Thanks

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You wouldn't as that would result in data duplication.
    Instead you concatenate the two fields using a query for use in forms & reports as needed.
    Code:
    [Final Product Code] : [Lot No]  & "." & [Product Code]
    As a side issue, I recommend you don't use special characters such as spaces in field names as these can lead to typing errors. Also using them means that all fields have to be wrapped in []
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Grahamiwa is offline Novice
    Windows 98/ME Access 97
    Join Date
    May 2011
    Posts
    6
    Worked very well thanks

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Excellent. Good to hear.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 09-19-2018, 09:20 AM
  2. find values based on text criteria
    By boboivan in forum Access
    Replies: 2
    Last Post: 12-09-2015, 05:37 AM
  3. Replies: 1
    Last Post: 02-19-2014, 11:07 AM
  4. Replies: 1
    Last Post: 03-01-2012, 04:35 AM
  5. Replies: 2
    Last Post: 05-05-2010, 02:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums